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
|