Formula to calculate # of weeks from start date

Platform discussions
1

I need to track the current week of a program based on the start date. So if we are in week 1, I want the formula column to say week 1. If we are in week 2, it should say week 2. Can anyone help me with setting up this formula?

2

Hi @Tara-Horn - something like this could work:

"Week " & (ROUND(DAYS(TODAY(),{Start Date})/7,0)+1)

Thanks!
Mark

3

Thank you @mark.anley this worked!

1 Like