| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date/Time
Trying to determine if the date and the time in a cell are the last
day of the month, and if that's the case I want to perform a certain operation. Here's what I have so far: =IF(NOT(DATE(YEAR(A1),MONTH(A1)+1,0)),1,0) A1 is 2/29/08 My formula returns 0, I would expect this to return a 1 as 2/29/08 IS the last day of February... Any ideas why this might not be working? Thanks Chris |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating days & time left from start date/time to end date/time | Excel Worksheet Functions | |||
| Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
| Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
| Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
| Combined date time cell to separate date & time components | Excel Worksheet Functions | |||
Threaded Mode
