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

Hi Malcolm

In A1 enter 28/02/05 (or any other calendar date that is a Monday) and
format the cell Custom=ddd.
This will show as Monday
Then, in B1 enter =A1+1 having formatted the cell in the same way.

--
Regards
Roger Govier
"Malcolm Austin" wrote in 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

Malcolm,

If you have entered a Monday date in cell A1 and formatted to show just the
day by using custom format then =A1+1 will return Tuesday. To format chose
Format menu, Cells..., Number tab, Custom (last option) then type in dddd.

Hope this helps, Rob

"Malcolm Austin" wrote in 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

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


.

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


.

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


.

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


.

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


.

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


.

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


.









.

On Sat, 05 Mar 2005 18:23:37 GMT, "Malcolm Austin"
wrote:

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


You did specify a function in B1:

=CHOOSE(MATCH(A1,{"Monday";"Tuesday";"Wednesday";" Thursday";"Friday";"Saturday";"Sunday"},0),
"Tuesday","Wednesday","Thursday","Friday","Saturda y","Sunday","Monday")

--ron

just drag by the fill handle(i.e right bottom of the cell when cursor
becomes +)


Ron Rosenfeld wrote in message
...
On Sat, 05 Mar 2005 18:23:37 GMT, "Malcolm Austin"
wrote:

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


You did specify a function in B1:


=CHOOSE(MATCH(A1,{"Monday";"Tuesday";"Wednesday";" Thursday";"Friday";"Saturd
ay";"Sunday"},0),
"Tuesday","Wednesday","Thursday","Friday","Saturda y","Sunday","Monday")

--ron

On Mon, 7 Mar 2005 08:32:20 +0530, "R.VENKATARAMAN" wrote:

just drag by the fill handle(i.e right bottom of the cell when cursor
becomes +)

As I wrote, the OP wanted a "worksheet function". I do not consider the fill
process, which had been mentioned previously, to be a "worksheet function".


--ron