G
Guest
I have a simple grid spreadsheet with a list of road names down the left and
1st cut, 2nd cut, 3rd cut etc along the top. The idea is to show how many
times the grass in each road is cut. There should be one cut every two weeks
and the date of that cut is then entered. What i would like to do is create a
formula whereby all the roads against 1st cut automatically display the
message 'overdue' if they haven't been visited within two weeks of the start
date (the start date could be 1st January for instance). The 2nd cut should
be four weeks from the start, 3rd cut six weeks so on and so on.
Any help would be greatly appreciated
Thanks
Craig
1st cut, 2nd cut, 3rd cut etc along the top. The idea is to show how many
times the grass in each road is cut. There should be one cut every two weeks
and the date of that cut is then entered. What i would like to do is create a
formula whereby all the roads against 1st cut automatically display the
message 'overdue' if they haven't been visited within two weeks of the start
date (the start date could be 1st January for instance). The 2nd cut should
be four weeks from the start, 3rd cut six weeks so on and so on.
Any help would be greatly appreciated
Thanks
Craig