Date & Timebeginner
Add or subtract months from a date with EDATE
=EDATE(A2,12)
Date & Time
Date & Time formulas
Calculate durations, working days, deadlines, and date differences with precision.
Date & Timeintermediate
Calculate a due date skipping weekends with WORKDAY
=WORKDAY(A2,30)
Date & Timeintermediate
Calculate age in years with DATEDIF
=DATEDIF(A2,TODAY(),"Y")
Date & Timebeginner
Count days remaining until a deadline with TODAY
=A2-TODAY()
Date & Timebeginner
Extract month and year from a date with MONTH and YEAR
=YEAR(A2)&"-"&TEXT(MONTH(A2),"00")
Date & Timebeginner
Get the last day of a month with EOMONTH
=EOMONTH(A2,0)
Date & Timebeginner
NETWORKDAYS for project timeline planning
=NETWORKDAYS(B2,C2)
Date & Timebeginner
Show the day name from a date with TEXT
=TEXT(A2,"DDDD")
Frequently asked questions
How do I calculate the last day of a month N months away?
Use EOMONTH(A2, N) — it returns the last day of the month that is N months from the start date.
How do I also skip public holidays?
Store your holiday dates in a separate range, for example H2:H20, and add it as the third argument — =WORKDAY(A2,30,H2:H20).
How do I also show the remaining months after the full years?
Add a second DATEDIF with the "YM" unit — =DATEDIF(A2,TODAY(),"Y")&" years, "&DATEDIF(A2,TODAY(),"YM")&" months".
How do I show "Overdue" when the deadline has passed?
Use =IF(A2<TODAY(),"Overdue",A2-TODAY()) to display a label for past deadlines and a day count for future ones.