| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date fomula not working
.. I enter a month and day in A2
I'm not sure what your expression computes but A2 must contain a real date, not just any sort of number. A real date is a full valid, unambiguous date (day-month-year) recognized by Excel, eg: 01-Jan-2009. Try re-entering a real date into A2. -- Max Singapore http://savefile.com/projects/236895 Downloads:23,000 Files:370 Subscribers:66 xdemechanik --- "FangYR" wrote: I have use this last year, it's fine until now. the formula is now new to Ron, =DATE(YEAR(A2)-1,MONTH(A2),DAY(A2))-(MONTH(DATE(YEAR(A2)-1,MONTH(A2),DAY(A2)))<MONTH(A2)) That is, I enter a month and day in A2 and it will appear as last year's date, but now nothing changes, still in default year 2009. Please advise |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date Fomula Question | Excel Discussion (Misc queries) | |||
| Fomula only half working | Excel Discussion (Misc queries) | |||
| Fomula for number of days on each month from a date range | Excel Discussion (Misc queries) | |||
| fomula for working out profit | Excel Discussion (Misc queries) | |||
| the date format is not working ,sort by date doesn't work. | Excel Discussion (Misc queries) | |||
Threaded Mode
