Formula for dates

Copper Contributor

Hello, hope you're having a good day.


I'm having an issue with trying to make a formula for automatically dating several sheets.


I have several sheets for schedules at work from Sunday to Saturday. The sheets are named (sun am, sun pm, mon am, mon pm etc.) for each day of the week I have two separate sheets.


I'm trying to find or make a formula so I can change the dates on one sheet such as (mon am) and have it automatically date the other 14 sheets with the correct dates throughout the week but can never get it to work properly.


I got close the last time but at one point it started dating sheet (mon am) as the January 9th 2023 and (mon pm) as January 10th 2023.


Any help would be greatly appreciated. 

1 Reply


Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?