I'm not that good with Excel, so there could be something very visible I'm
missing.

I have a date for the beginning of the week "6/18/2007" in F4.

I then have five cells that stand for the days of the week. I want to be
able to enter Monday's date (18) and put a equation in the five cells that
will calculate their dates automatically.

I think I have to transfer 6/18/2007 into Excel numbers, which is 39251. And
then put it back into regular time with the DAY function.

=DAY((DATEVALUE(F4))+Y)
Y being adjustment for the date (ex. +2 for Wendsday.

But I get an error. Any help would be welcome.

Not as complicated as that. Put your date in F4 and in G4 put

=F4+1

Drag this right for as many days as you want and then select the cells and
format them as date.

Mike

"Extorris" wrote:

I'm not that good with Excel, so there could be something very visible I'm
missing.

I have a date for the beginning of the week "6/18/2007" in F4.

I then have five cells that stand for the days of the week. I want to be
able to enter Monday's date (18) and put a equation in the five cells that
will calculate their dates automatically.

I think I have to transfer 6/18/2007 into Excel numbers, which is 39251. And
then put it back into regular time with the DAY function.

=DAY((DATEVALUE(F4))+Y)
Y being adjustment for the date (ex. +2 for Wendsday.

But I get an error. Any help would be welcome.

Your working to hard on this one. In F4 put the Monday date. For the next
cell for Tue. simply enter the formula F4 + 1. The date for Tue should
appear. If it does not you just neet to format the cell as a date. Hope
this helps.


"Extorris" wrote:

I'm not that good with Excel, so there could be something very visible I'm
missing.

I have a date for the beginning of the week "6/18/2007" in F4.

I then have five cells that stand for the days of the week. I want to be
able to enter Monday's date (18) and put a equation in the five cells that
will calculate their dates automatically.

I think I have to transfer 6/18/2007 into Excel numbers, which is 39251. And
then put it back into regular time with the DAY function.

=DAY((DATEVALUE(F4))+Y)
Y being adjustment for the date (ex. +2 for Wendsday.

But I get an error. Any help would be welcome.

Thanks. I know now I can put ="Tues"&DAY($F$4+1) which equals Tues19. How do
I get the a space to get Tues 19?

"bucbanzai" wrote:

Your working to hard on this one. In F4 put the Monday date. For the next
cell for Tue. simply enter the formula F4 + 1. The date for Tue should
appear. If it does not you just neet to format the cell as a date. Hope
this helps.


"Extorris" wrote:

I'm not that good with Excel, so there could be something very visible I'm
missing.

I have a date for the beginning of the week "6/18/2007" in F4.

I then have five cells that stand for the days of the week. I want to be
able to enter Monday's date (18) and put a equation in the five cells that
will calculate their dates automatically.

I think I have to transfer 6/18/2007 into Excel numbers, which is 39251. And
then put it back into regular time with the DAY function.

=DAY((DATEVALUE(F4))+Y)
Y being adjustment for the date (ex. +2 for Wendsday.

But I get an error. Any help would be welcome.