Calculating remaining days of month

[samwagner]

Is there a way to calculate the exact number of renaining days in the current month?

Examples:

Today is 01/30/2024. So the number of full remaining days in January is 1.

If today was 02/02/2024, the number would be 27 (leap year!)

So what formula will give back the exact number for every given date (NOW)?

Thanks in advance.

[Antonino_Nolasco]

Hi @samwagner
Change “Date” with your Date column:

Day(Date-Day(Date)+45
-
Day(Date-Day(Date)+45))-Day(Date)

[samwagner]

So awesome!

Thanks a bunch, @Antonino_Nolasco