Date question (novice)

  • Thread starter Thread starter Pitstop
  • Start date Start date
P

Pitstop

I have a date in cell W1, 18.10.09 and the cell is formatted dd.mm.yy.
What I'd like to do is get
cell B7 to show 18.10,
cell B6 to show 17.10,
cell B5 to show 16.10 etc to Cell B1 (sunday to monday)

I've tried saying B7 is =W1 and formatted dd.mm but that doesn't work as it
just copies W1 exactly and ignores formatting.

Any ideas?
Thanks
Pete
 
I suspect the value in W1 is a text value, although it might look to
you like it is a date. You will need to enter it into the cell as
18/10/09 (i.e. with the slashes) and Excel will display it as 18.10.09
(with full-stops) if it has been formatted as dd.mm.yy.

Then in B1 you can put the formula:

=W1-8+ROW(A1)

and format this cell as dd.mm, and then you can copy B1 down to B7 to
give you the other dates.

Hope this helps.

Pete
 
Back
Top