Date formulae

New Contributor
I need a formula or code to convert like for example Nov/wk3 into dates, either start date of week or end date
5 Replies

@100rabba 

It depends on for which year to calculate. And what do you consider as first week within month - with first Monday, first Sunday, just any day of the week or something else?

For current year say (2022, Nov/wk3) to return date?

@100rabba 

Okay, thank you. But when wk1 starts, e.g. for May 2022 (1st of May is Sunday) ?

Ya the same may 1st week will be from 1st May to 7th may. As per calendar format

@100rabba 

Perhaps that's for US, my calendar format shows

image.png

(week starts on Monday). I guess we may find the month where the 1st is Sat, thus in US calendar it'll be similar picture. It's desirably to have more formal logic what is considered as first week of the month. For above that could be start and end of the 1st week 01st of May, 2nd week starts on 02 and ends on 08. It could be another logic, e.g. exclude weekends, etc.