Hi,
I have nearly completed a spreadsheet that is designed to advise what backup tape has to be used on a customers server, depending on what day of the week it is.
Most of the customers have a basic rotational pattern and these are all fine.
However, I need a formula that will work out the following:
Tapes rotate 1 through 3 with the last Friday of the month having a monthly tape inserted. Tapes are only inserted on a Friday.
I had at first thought of simply rotating 1,2,3,month tape but this month we have 5 Fridays so it would need to be 1,2,3,1,month tape.
Any help GREATLY appreciated.
Rgds
Diane
Bookmarks