Setting a Timesheet with Dates
 

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.

Setting a Timesheet with Dates
 

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.

Setting a Timesheet with Dates
 

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.

Setting a Timesheet with Dates
 

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.