I have used this formula =DATE(YEAR(E5), MONTH(E5) + 24, DAY(E5)) to calculate when training is due. However for employees that don't yet have training (the original date cell E6 is left blank) it creates a date "31-Dec-01" in AS6. I need it to instead create no date in AS6 if E6 has no date.
Can anyone help me do this?
Bookmarks