G
gATOR gIRL
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
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