After reading Bif's reply, I glanced at the OP and saw "function", which is
one of my major shortcomings (glancing instead of attempting to fully
comprehend), and took for granted an XL date might have been part of the
conversation.<g

--

Regards,

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

"Bob Phillips" wrote in message
...
No argument there, it was the ... If you're going to go that route (not a
true date), ... that I was referring to

Bob


"RagDyeR" wrote in message
...
So , the question is STILL ... why key in Tuesday before you drag to
autofill?<g
--

Regards,

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

"Bob Phillips" wrote in message
...
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


.