Looks like you want to return the first Sunday after the 2nd of the month. If
the first day of the month is shown in A1 as Ron suggests then use this
formula

=A1+9-WEEKDAY(A1+1)

"Ron Coderre" wrote:

I'm not sure where you're getting the date from
so I'll assume cell A1 contains the date

With
A1: 01/01/2007

Try this
B1: =8-MOD(WEEKDAY(A1,2),6)+(WEEKDAY(A1,2)5)

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP


"Ken" wrote:

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