Sometimes MY autofill has a mind of it's own!
Biff
-----Original Message-----
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
.
.
|