|
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 |
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 |
| All times are GMT +1. The time now is 04:41 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com