He asked for a day, not date

Bob

"RagDyeR" wrote in message
...
If you're going to go that route (not a true date), why bother with keying
in Tuesday?<g

--

Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
--------------------------------------------------------------------

"Biff" wrote in message
...
Hi!

In A1 enter Monday
In B1 enter Tuesday

Select both A1 and B1. "Grab" the fill handle and copy
across!

Biff

-----Original 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


.