cell display depending on date

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

Many thanks

Have used the below as I am linking back to another cell

=IF(MONTH(A14+5)>MONTH(A14),"Month Tape","Tape "&(MOD(WEEKNUM(A14)-MONTH(A14)+1,3)+1))


and this works OK. However, after the month tape is used I need to start at Tape 1 again.

So I may have Tape 1, Tape 2, Tape 3, Tape 1, Month Tape (last Friday of month), Tape 1 .......... as the rota. Is there anyway to do this?

Thanks again,
Diane