DAY FUNCTION

[Malcolm Austin]

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

 

[Roger Govier]

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.

 

[Rob]

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

 

[Biff]

Hi!

In A1 enter Monday
In B1 enter Tuesday

Select both A1 and B1. "Grab" the fill handle and copy
across!

Biff

 

[RagDyeR]

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

Hi!

In A1 enter Monday
In B1 enter Tuesday

Select both A1 and B1. "Grab" the fill handle and copy
across!

Biff

 

[Bob Phillips]

He asked for a day, not date

Bob

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

Hi!

In A1 enter Monday
In B1 enter Tuesday

Select both A1 and B1. "Grab" the fill handle and copy
across!

Biff

 

[RagDyeR]

So , the question is STILL ... why key in Tuesday before you drag to
autofill?<g>

 

[Bob Phillips]

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]

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

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

Bob

 

[Biff]

Sometimes MY autofill has a mind of it's own!

Biff

 

[Ron Rosenfeld]

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","Saturday","Sunday","Monday")

--ron

 

[Ron Rosenfeld]

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