Excel help repeating event

[BillWright]

Hello

I've tried searching with no good result. I have an Excel spreadsheet with the first row showing the week commencing date, and the second row the ISO week number.

I want to enter the dates of the safety inspections for a vehicle fleet that are due every six weeks for the next two years.

Is there a way to repeat the text entry of the event at these intervals?

 

[Mzokk]

Do you need to record all the weeks or just the weeks the inspections take place?

 

[SBD]

Is there a rule, like you want to copy the cell contents to a given week of each month? Or week 10, 20, 30 etc?

If so create an “if” statement to use the rule and if true, make the test cell equal to the example, otherwise blank.

 

[BillWright]

Thanks for your replies. The PMI, or safety inspection is required every six weeks. I was trying to replicate this event every six ISO weeks for say 104 weeks, rather than manually enter each event.

 

[DrFarkoff]

Thanks for your replies. The PMI, or safety inspection is required every six weeks. I was trying to replicate this event every six ISO weeks for say 104 weeks, rather than manually enter each event.

the easy way is to keep it simple, Set up your date column

Format all the cells in that column (Except the top one as it will be the description) as a date

Select the top cell of where you want to start and for Example it is cell D2 and enter that date

In D3 , enter an equals sign then select the cell above and then (+42 no spaces) and then enter

it will say D2+42 and then grab the bottom right of that cell where it becomes a cross (in excel, Blue dot in sheets) when hovered over and just drag it as far as you want

 

[SBD]

That’ll work, or you can do it in weeks rather than days, using your iso weeks column and “if (it equals the last time plus six weeks) …”

 

[BillWright]

I have a different format to that.
I have shown a copy.