Looking for formula(s) to determine number of months, weeks, days remaining.

Jason F

I have a beginning date and an end date. Looking for a formula to determine the countdown but in month, week, day form.

i.e. (3 months, 1 week, 6 days remaining until end)

Melissa Yamada

Hello @Jason F

Try this:

For Days:

=TODAY() - [End Date]@row

For Weeks:

=(TODAY() - [End Date]@row) / 7

For Months:

=SUM(12 * (YEAR([End date]@row) - YEAR(TODAY())), MONTH([End date]@row) - MONTH(TODAY()))