Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hi,
My formula: IF($H$37<MONTH(3)*YEAR(2005),"",$H$37+3) IF H37 is less than or grater than March 2005 (not in March) then, display nothing, elae (if it is in March)display the date+3. I want it to display a date in March only not in any other month. H37 has March 26, 2005 in it. I want the formula cell to display March 29th. If H37 has no date I want the formula cell to display nothing and if the H37+3 is in April and not in March I want nothing displayed also, diaplay only if the +3 is a date in March. What I get with the above is nothing if there is a date in March. When I change the formula to the following I get the correct date but this is wrong: IF($H$37<MONTH(3)*YEAR(2005),$H$37+3,"") SO what have I done?? What should I do! Thank you, JK |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
extract date from the most current date | Excel Discussion (Misc queries) | |||
Date Math Problem | Excel Worksheet Functions | |||
Use a calc to figure sum in months using date fields but numeric r | Excel Worksheet Functions | |||
Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
calc constant date from variable date & return with ability to rn. | Excel Worksheet Functions |