Count days between set date each year

Platform discussions Special workflows & use cases
1

Hi Guys!

Does anyone know how to calculate the days between a given date and a set date each calendar year? So for this year I need the number of days to 31st May 2022 and then once 31st May has passed, the days to 31st May 2023 and so on. Thanks

2

@leeayliff

I’m not 100% sure that I understand your request. But, here goes…
Try this:

IF(FORMAT_DATE(TODAY(),"MM-DD") > FORMAT_DATE({Date}, "MM-DD"), 

ROUNDUP(DAYS(TODAY(), YEAR(TODAY()) & FORMAT_DATE({Date}, "-MM-DD")), 0), 

ROUNDUP(DAYS((FORMAT_DATE(TODAY(),"Y") + 1) & FORMAT_DATE(TODAY(), "-MM-DD"), YEAR(TODAY()) & FORMAT_DATE({Date}, "-MM-DD")), 0))

Jim - The Monday Man (YouTube Channel)
Watch Our Latest Video: Column Total in monday.com Formulas? YES!!!

3

Hi Jim, trying to do something similar and hoping you can assist me. I am trying to calculate the day of year it is today but based on the last day of last year. Where the last day of year is part of the formula calculated on what day it is each today. I have tried numerous things and cant seem to figure this out. I’m not a programmer but quite technical regardless.

Also, if there is a place for me to learn this type of language you could recommend. Please do. Thank you in advance. John