Projecting Jobs due calendar

I wonder if anyone can help??

I have attached an example file to try and make things more clear.


The aim of the worksheet is to project reoccurring jobs ( eg. a window cleaning round) on a 'at a glance calendar'.

The date last done is entered and the interval in days - from that (behind the scenes) I would like to calculate a list of the following dates the job is due.

Then in the corresponding date column I would like the price of the job to show up. (the reference for the price of the job would be hidden in column FS)

I will then do a filter for non blanks to see the work due that day and the total at the top will give me an idea of how full the day is.


Thank you for your help!!

hope this can help you

Many thanks sglife - you are a superstar!

Sorry to be a pest, but is there a way to include the date of column A in the calendar too?

No worries, I just had an idea that worked. I put another IF clause at the beginning so if the date of column A is the same as the date of the calendar the result shows up as Price per clean, if not it falls back to the usual formula.

I'm slowly getting the hang of this...