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


.