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