Formula to calculate # of weeks from start date

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?

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

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


Thank you @mark.anley this worked!

1 Like