Auto Update date cycle

[CDandVinyl]

In Cell A1 , I have the start date for my project in dd mmm yyyy format.

In C6 , I'd like to show the date 28 days from my start date.

Once the cycle of 28 days has passed the date in C6 should change to show the next cycle date.

So for example , if my start date in A1 is 10 Feb 2023 , then the date showing in C6 would have been 10 Mar 2023. Once that date passed , C6 would update to the next date in the 28 day cycle , which would be 07 Apr 2023. Once this date has passed it would change to the next one (05 May 2023), and so on.

Can someone offer a formula to satisfy this?


Always grateful for any help.

[Roel Jongman]

Try this formula

Please Login or Register  to view this content.

[Keebellah]

Well, probably something like this (see attached sample)
What I did was create a list of dates for a cycle of 28 dates from startdate, that calculation is the startdate + the rownumber -1 * the cycledays
In C6 a formula

Please Login or Register  to view this content.

The first dat by approximation is march 10 and I added 28 days to that
When today's date reaches April 7 the next cycle will be that date + 28 etc.

The range name for A1 is STARTDATE and the range name vor B1 is CYCLE this way you can either decide on another cycle value and just change the date in A1 and the list will always be correct

Once you have a working sheet you can place the cycle value and the list value in another scheet not visible to the user so just the startdate is here and C6

Hope you grasp my idea but Joel Jongman's formula is simpler but I'm no good at formula's

[CDandVinyl]

Keebellah - really clever use of helper columns. This works fine. Thank you.

hi Roel Jongman. Thanks for the formula. I'm afraid it gives #NAME? errors. It might be my version of Excel. I'm not sure.

[Keebellah]

True,

CEILING function
Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel for the web Excel 2021 Excel 2021 for Mac Excel 2019 Excel 2019 for Mac Excel 2016 Excel 2016 for Mac Excel 2013 Excel 2010 Excel 2007 Excel for Mac 2011 Excel Starter 2010 Less
This article describes the formula syntax and usage of the CEILING function in Microsoft Excel.

https://support.microsoft.com/en-us/...c-c943e510899f
Have you tried my solution?

[CDandVinyl]

Keebellah - Thanks for the link about the CEILING function. It does seem to give errors in my version of Excel , even though it says it should work. This is a little mysterious...!

Yes , I implemented your solution and it works very well. Thank you.