Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dave Peterson Answer
Dave gave me this correct answer of
=if(weekday(a1)=1,text(a1,"dddd"),"Wrong Date") to my question of how to be sure an input date was on a Sunday Where do all you experts find these answers? Are they written down somewhere? What does "dddd" mean? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dave Peterson Answer
The answers are found with experience.
Dave -- Brevity is the soul of wit. "Oldjay" wrote: Dave gave me this correct answer of =if(weekday(a1)=1,text(a1,"dddd"),"Wrong Date") to my question of how to be sure an input date was on a Sunday Where do all you experts find these answers? Are they written down somewhere? What does "dddd" mean? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dave Peterson Answer
And the "dddd" is a formatting string, one that tells the Excel function TEXT to format the value in
A1 as a named date. For example, with today's date 10/24/06 in cell A1 =TEXT(A1,"0") returns 39014 =TEXT(A1,"d") returns 24 =TEXT(A1,"dd") returns 24 =TEXT(A1,"ddd") returns Tue =TEXT(A1,"dddd") returns Tuesday =TEXT(A1,"m") returns 10 =TEXT(A1,"mmm") returns Oct =TEXT(A1,"mmmm") returns October =TEXT(A1,"mmm dd, yyyy") returns Oct 24, 2006 HTH, Bernie MS Excel MVP "Dave F" wrote in message ... The answers are found with experience. Dave -- Brevity is the soul of wit. "Oldjay" wrote: Dave gave me this correct answer of =if(weekday(a1)=1,text(a1,"dddd"),"Wrong Date") to my question of how to be sure an input date was on a Sunday Where do all you experts find these answers? Are they written down somewhere? What does "dddd" mean? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dave Peterson Answer
Also, if you look at Excel's help for: Number format codes
You'll find a lot of information for times/dates/and just regular old numbers. Oldjay wrote: Dave gave me this correct answer of =if(weekday(a1)=1,text(a1,"dddd"),"Wrong Date") to my question of how to be sure an input date was on a Sunday Where do all you experts find these answers? Are they written down somewhere? What does "dddd" mean? -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dave Peterson Answer
Thanks very mutch.
But where would I go if I didn't have you smart guy and ladies "Bernie Deitrick" wrote: And the "dddd" is a formatting string, one that tells the Excel function TEXT to format the value in A1 as a named date. For example, with today's date 10/24/06 in cell A1 =TEXT(A1,"0") returns 39014 =TEXT(A1,"d") returns 24 =TEXT(A1,"dd") returns 24 =TEXT(A1,"ddd") returns Tue =TEXT(A1,"dddd") returns Tuesday =TEXT(A1,"m") returns 10 =TEXT(A1,"mmm") returns Oct =TEXT(A1,"mmmm") returns October =TEXT(A1,"mmm dd, yyyy") returns Oct 24, 2006 HTH, Bernie MS Excel MVP "Dave F" wrote in message ... The answers are found with experience. Dave -- Brevity is the soul of wit. "Oldjay" wrote: Dave gave me this correct answer of =if(weekday(a1)=1,text(a1,"dddd"),"Wrong Date") to my question of how to be sure an input date was on a Sunday Where do all you experts find these answers? Are they written down somewhere? What does "dddd" mean? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dave Peterson Answer
Thanks I have been looking in VBA help
"Dave Peterson" wrote: Also, if you look at Excel's help for: Number format codes You'll find a lot of information for times/dates/and just regular old numbers. Oldjay wrote: Dave gave me this correct answer of =if(weekday(a1)=1,text(a1,"dddd"),"Wrong Date") to my question of how to be sure an input date was on a Sunday Where do all you experts find these answers? Are they written down somewhere? What does "dddd" mean? -- Dave Peterson |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dave Peterson Answer
I don't know who gets the credit for the adage "genius is 99% hard work
and 1% inspiration" but it sure feels true. Without necessary claiming the mantle of genius, I find 99% of the time I find solutions through hard work -- the help file, google, the msdn archives, asking seemingly dumb questions of myself and of others, and lots and lots of trials-with-many-an-error. Once in a while I do have an inspiration. "Gee, I wonder what would happen if I combined this with that?" Or "conceptually, if I can do this, I should be able to do that." Or, out of the clear blue sky, "Gee, I wonder if I can do this?" And, on more than one occasion, it has been sheer desperation. "Nothing I've tried has worked. Let me try this seemingly absurd -- absolutely absurd -- idea. And, this variation, and that variation, and..." -- Regards, Tushar Mehta www.tushar-mehta.com Multi-disciplinary business expertise + Technology skills = Optimal solution to your business problem Recipient Microsoft MVP award 2000-2007 In article , says... Dave gave me this correct answer of =if(weekday(a1)=1,text(a1,"dddd"),"Wrong Date") to my question of how to be sure an input date was on a Sunday Where do all you experts find these answers? Are they written down somewhere? What does "dddd" mean? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Deleting Duplicate items in a ListBox | Excel Discussion (Misc queries) | |||
general macro question | Excel Discussion (Misc queries) | |||
Combo Box or Data Validation | Excel Discussion (Misc queries) | |||
Concatinate a filename | Excel Discussion (Misc queries) | |||
Office Excel 2003 Versions and VBA | Setting up and Configuration of Excel |