Hi Malcolm
In A1 enter 28/02/05 (or any other calendar date that is a Monday) and
format the cell Custom=ddd.
This will show as Monday
Then, in B1 enter =A1+1 having formatted the cell in the same way.
--
Regards
Roger Govier
"Malcolm Austin" wrote in message
...
I know I'm going to kick myself when I get the reply on this, but...
How do I get a day (Monday) to update to Tuesday with a worksheet
function.
If I have Monday in A1, and want Tuesday in B1, what do I write? A1+1
doesn't seem to
work and I don't see a format just for days?
Please put me out of my misery !!
Malcolm
|