Setting a Timesheet with Dates

[Guest]

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.

 

[Guest]

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

 

[Guest]

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.

 

[Guest]

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?

 

[David Biddulph]

If you wanted to use that dreadful way of doing things and wished to include
a space, then you could use
="Tues "&DAY($F$4+1),
but *please* don't do it that way! [... and please read the advice that
you've already been given.]

If your number in F4 6/18/2007 is recognised as a date, then =F4+1 will be
recognised as 6/19/2007.
If you want to see it displayed as Tue 19 you can format the cell as ddd dd.
If you want Tuesday 19, format as dddd dd.