I HAVE A CALENDAR SET UP BY WEEK, WITH COLUMNS FOR EACH DAY, AND THE FIRST OF
THE YEAR DATE, SUCH AS 1/1/10, IN CELL C2.
__________________________________________________ _______________
C2 1/1/10
__________________________________________________ ______________
DATE? | SUNDAY DATE? | MONDAY DATE? |WEDNESDAY etc

I WANT TO CREATE A FORMULA THAT WILL LOOK AT THE DATE IN C2, AND THEN ASSIGN
THE PROPER DATES FOR EACH COLUMN, BASED ON THE DAY OF THE WEEK. IF THE
FIRST FALLS ON A WEDNESDAY, I'D WANT 0 AS THE DATE FOR SUNDAY, MONDAY TUESDAY.

I'M WORKING IN EXCEL 2003 AT HOME, BUT WILL THEN SEND TO WORK, WHERE IT WILL
BE IN EXCEL 2007.
THANKS