| Home |
| Search |
| Today's Posts |
|
#5
|
|||
|
|||
Thanks all for your suggestions ...
jer "Arvi Laanemets" wrote: Hi MONTH(3)=MONTH("01/03/1900")=1 DAY(30)=DAY("01/30/1900")=30 -- When sending mail, use address arvil<attarkon.ee Arvi Laanemets "jer" wrote in message ... This may be very simple but the result is not what I expect, any help suggestion would be greatly appreciated. In cell a1 I have 10/15/2004 in cell b1 I put in the formula =DATE(YEAR(A1)+1,MONTH(3),DAY(30)) I am expecting the result to be 03/30/2005, however the result I am getting is 01/30/2005. Any suggestions -- thanks as always for the help jer |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date Function | Excel Discussion (Misc queries) | |||
| Using date function in an if statement | Excel Worksheet Functions | |||
| Date function | Excel Worksheet Functions | |||
| Calculating days between current date and a date in future NETWORKDAYS() function | Excel Worksheet Functions | |||
| Formula for date function | Excel Worksheet Functions | |||
Threaded Mode
