Inserting a formula that returns the number of days left in a month
Insert the following formula into a cell:
DATEDIF(TODAY(),EOMONTH(A1,-1),"D")
So, if today's date is March 9, 2025, the formula returns 22.
MacBook Air 13″, macOS 15.3
Question marked as
Are you sure your formula works?
If A1 is March 9, 2025 then EOMONTH(A1,-1) gives you February 28 not March 31 and DATEDIF will give an error because the first date is later than the second. You need to change the -1 to a 0.
Your formula uses TODAY() in part of it and a reference to cell A1 in another part. The formula (after changing the -1 to a 0) will give you the correct answer as long as A1 is in the same month as TODAY, but not otherwise. Why not use A1 in both places or TODAY() in both places?
=DATEDIF(TODAY(),EOMONTH(TODAY(),0),"D")
