Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculation with EDATE Help Needed!
The formula below is producing an "#N/A" error.
=IF(K5="","",IF(TODAY()EDATE(H5+45),"Failed to Enroll on Time")) What I am trying to do is the following: If a date is posted in cell K5 (which is the enrollment date) than the second half of the formula should not produce the FLAG "Failed to Enroll on Time" regardless. If a date is NOT posted in cell K5, than the "Failed to Enroll on Time" flag should appear 45 days after the date posted in cell H5. Unfortunately I am getting the error message noted above (#N/A), and not the results I am trying to obtain.......... Thanks in advance! Dan |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculation with EDATE Help Needed!
I don't think you need EDATE, Dan. EDATE is used to add a number of
months to a date. Try this =IF(H5="","",IF(AND(K5="",TODAY()H5+45),"Failed to Enroll on Time","")) |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculation with EDATE Help Needed!
Thank you very much Barry..............Sorry I didn't respond quicker, as I
had a work crisis that I needed to deal with......................Happy New Year! Dan "Danny Boy" wrote: The formula below is producing an "#N/A" error. =IF(K5="","",IF(TODAY()EDATE(H5+45),"Failed to Enroll on Time")) What I am trying to do is the following: If a date is posted in cell K5 (which is the enrollment date) than the second half of the formula should not produce the FLAG "Failed to Enroll on Time" regardless. If a date is NOT posted in cell K5, than the "Failed to Enroll on Time" flag should appear 45 days after the date posted in cell H5. Unfortunately I am getting the error message noted above (#N/A), and not the results I am trying to obtain.......... Thanks in advance! Dan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculation needed maybe a pivot table - Thank you | Excel Discussion (Misc queries) | |||
Help needed with a calculation question | Excel Worksheet Functions | |||
date/time calculation needed | Excel Worksheet Functions | |||
Financial Calculation Help Needed -- Annunity | Excel Worksheet Functions | |||
Time Sheet Calculation Help Needed! | Excel Worksheet Functions |