If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#24
|
|||
|
|||
Date fomula not working
Sorry, this one is correct
type 1/3 in A2. 39085 appeared in G2. -- Regards FangYR Malaysia "Rick Rothstein" wrote: Telling us a result without telling us your input is meaningless... exactly what did you type into A2 to get that 693231 value? -- Rick (MVP - Excel) "FangYR" wrote in message ... In G2 , =DATE(YEAR(A2)-2,MONTH(A2),DAY(A2))-(MONTH(DATE(YEAR(A2)-2,MONTH(A2),DAY(A2)))MONTH(A2)), number appeared, 693231. any idea? -- Regards FangYR Malaysia "David Biddulph" wrote: You'll need to tell us precisely what values you've got in which cells. If you use the formula =A2 and format as General, what number do you have? If you use the formula =G2 and format as General, what number do you have? -- David Biddulph "FangYR" wrote in message ... I place the formula in G2, format cell A2 as dd-mmm-yyyy. whatever date style I enter, the year is still "2009". It refuse to compute! Ai!!! -- Regards FangYR Malaysia "Max" wrote: .. in A2, I enter "1/3" (ie 3th Jan) and I expect A2 to read "3 Jan 2008", but "3 Jan 2009" appeared. well, that was precisely my point/sugegstion to you in my earlier response, A real date is a full valid, unambiguous date (day-month-year) recognized by Excel, eg: 01-Jan-2009. If you always practice entering dates as full dates, you won't get caught out with ambiguities such as what happened as you described. If you don't enter the date with the year in it - that's what you did, Excel will then assume the year is the current year (from the PC's clock), hence you get: "3 Jan 2009". You got "3 Jan 2008" previously because you entered it sometime last year (in 2008). Take my suggestion, never skimp on the data entry step when it comes to dates. Always enter it unambiguously in full, inclusive of the year, and use "mmm" format to denote the month as well in the date entry. -- Max Singapore http://savefile.com/projects/236895 Downloads:23,000 Files:370 Subscribers:66 xdemechanik --- |
Thread Tools | |
Display Modes | |
|
|