Traditional Culture Encyclopedia - The 24 Solar Terms - Excel table calculates the date to the end of the year according to different years?
Excel table calculates the date to the end of the year according to different years?
Use EOMONTH+MONTH to find the last day of the year, and then use DATEDIF to calculate the number of days from that date to the end of the year.
Formula:
=DATEDIF(A2，EOMONTH(A2， 12-MONTH(A2))，" d ")
- Related articles
- How to match the throttle of Jetta?
- Gui Shui was born in the month.
- What are the effects of earthly branches and Tibetan trunks on the Japanese Lord?
- How far is it from Changshu to Qingyang County, Chizhou City?
- Agricultural activities and health preservation methods of solar terms in Grain Rain
- When is Children's Day in 2022?
- What is this ancient poem in Fengcheng's New Year speech?
- How to set the WeChat bubble? colleague
- Proverbs about crouching
- What were the patriotic artists in War of Resistance against Japanese Aggression's time?