Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
DAY FUNCTION
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 . |
#5
|
|||
|
|||
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 . |
#6
|
|||
|
|||
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 . |
#7
|
|||
|
|||
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 . |
#8
|
|||
|
|||
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 . |
#9
|
|||
|
|||
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 |
#10
|
|||
|
|||
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 |
#11
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions | |||
Conversion | Excel Worksheet Functions | |||
Trim function doesn't clean out ASCII Code 160 (Space) | Excel Worksheet Functions | |||
Formula to list unique values | Excel Worksheet Functions | |||
change function variable prompts?? | Excel Worksheet Functions |