Help with a week formula

Rainier Hollands

Hi,

I need assistance in creating a formula in which it tells me what week we are into the month, so every month on the first it must start at week 1 and then every Monday thereafter it needs to go to the next week please?

Regards

Rainier

Paul Newcome

@L@123 I feel like we worked on this very thing some time ago, but I can't remember what your solution ended up being. Thoughts?

L_123

This is what I have so far, but it doesn't work if the month starts on sunday... i'm digging into it and will let you know

=ROUNDUP(NETDAYS(DATE(YEAR(a@row), MONTH(a@row), 1) - WEEKDAY(DATE(YEAR(a@row), MONTH(a@row), 1)) + 2, a@row) / 7))

Paul Newcome

That was a lot further back than I thought. Here is a similar thread from the end of May 2020...

https://community.smartsheet.com/discussion/68672/how-to-count-current-week-for-the-month

L_123

Oh yeah, I remember that one. Ha I'm adding that to my date formulas post so I don't have to look through comments to find it in the future

Rainier Hollands

@L@123 @Paul Newcome

Thank you so much for your assistance! Formula works perfectly!