Help with work schedule

[Minky79]

Hello. I really need some help in making a work schedule.

We are a cleaning company and we have regular jobs that we attend to, some every two weeks, others once a week. I am trying to create a table that shows the dates of the previous visits and also calculates the date the next visit is due. It sounds so simple but I have been trying to work it out for over a week.

Any help would be most appreciated!

[Ryan_G]

Can you input your Initial date in say cell A1, then B1 is one week later, formula: =(A1+7)? 2 weeks later in cell C1: =(B1+7) and so on? Likewise for previous weeks, just subtract 7?

[Minky79]

I feel so stupid now. I knew it would be really simple and I was over complicating things!

Thank you so much!

[Ryan_G]

No problem. Glad I could help. Be sure to format the cells with dates as the "Date" category.

[Minky79]

Will do. Thanks