Please: you have 12 "worksheets"
The "tabs" are the little things you click to open a worksheet
How are the worksheets named?
Or is there a cell in each worksheet that tells us which month it is for?
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email
"Ken" wrote in message
...
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