Formula request for recording weeks past a certain date


Looking for a formula to show weeks past from a date. So for example if an entry into the work flow was placed on the 21st July, I want to show the date column showing 2 weeks, then as this continues the week number adjusts accordingly to the length of time.

Any feedback would be greatly appreciated.

Hi @Oliverbowen,

Welcome to the community, and thanks for your question :smiling_face:

Can you please try this formula below? You will need to ensure you have the creation log column set up, so that the formula can log from the date the entry was added. You will also need to include the today function in the formula:

ROUNDDOWN(SUM(DAYS(TODAY(), {Creation Log#Date}),1)/7,0)&IF(ROUNDDOWN(SUM(DAYS(TODAY(), {Creation Log#Date}),1)/7,0)=1," week "," weeks ")&IF(MOD(SUM(DAYS(TODAY() , {Creation Log#Date}),1),7)<1,"","& "&ROUNDDOWN(MOD(SUM(DAYS(TODAY(), {Creation Log#Date}),1),7),0)&" days")

Please let us know if this works for you!


Hi Bianca,

That has worked perfectly, thank you for your assistance :smiley:


This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.