Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
DATE question
I was given a formula for one of my questions a while back and I am trying to
understand what it is doing. Below is the formula: =DATE(YEAR(A42),MONTH(A42)+1,0) If A42 = 1/15/09, then the above formula returns 1/31/09. My two questions a 1) Why doesn't MONTH(A42)+1 change the month to Feb? 2) What purpose does 0 in the day spot of DATE serve? Thanks, Les |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date Question | Excel Worksheet Functions | |||
Date question | Excel Worksheet Functions | |||
Date Question | Excel Discussion (Misc queries) | |||
This is a date question... | Excel Discussion (Misc queries) | |||
Another Date Question | Excel Discussion (Misc queries) |