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)

Find more posts tagged with

Formulas

Accepted answers

All comments

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()))

Isaac A.

Hi @Jason F!

After some testing and research, I found this related thread that could be helpful:
👉️ Formula to show duration (days) in months, weeks, and days

Here’s a potential formula you can try out:

=INT(([End Date]@row - [Start Date]@row) / 30) + " months " + INT(MOD([End Date]@row - [Start Date]@row, 30) / 7) + " weeks, " + MOD([End Date]@row - [Start Date]@row, 7) + " days remaining until end"

This formula provides an approximate breakdown based on a 30-day month and 7-day week.
I hope this helps you get started!

Cheers,
Isaac.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.