Forum Discussion
Solved
EDATE function - is this the right formula for my data
Hi, I am attempting to devise a training tracker and have set up the EDATE function to show courses that are expiring at different intervals i.e. 1, 2 and 3 years. I have set up the conditional f...
Step1) The formula that contains EDATE could read like:
=IF(ISBLANK(K7),"",EDATE(K7,12))
If I interpreted your question correctly, this will not calculate an end date for staff that do not require training.
The conditional formatting that you describe should work fine and it will not highlight cells that were left blank in step 1 above.
Step1) The formula that contains EDATE could read like:
=IF(ISBLANK(K7),"",EDATE(K7,12))
If I interpreted your question correctly, this will not calculate an end date for staff that do not require training.
The conditional formatting that you describe should work fine and it will not highlight cells that were left blank in step 1 above.
