Excel2003 ... I have 12 TabSheets (1 for each month ... Jan, Feb, Mar etc)

In each TabSheet I would like a cell result returned (format = mm/dd/yy)
based on the following:

If 1st day of ( Jan ) is a:

Mon ... Return value = 01/07/07
Tue ... Return value = 01/06/07
Wed .. Return value = 01/05/07
Thu ... Return value = 01/04/07
Fri ..... Return value = 01/03/07
Sat .... Return value = 01/09/07
Sun ... Return value = 01/08/07

Note: I will need to repeat formula for subsequent months ... Jan, Feb, Mar
etc ... Thanks ... Kha