#NUM! error
=INT(DATEDIF(J5,J3,"d")/7)&" Weeks "&MOD(DATEDIF(J5,J3,"d"),7)&" Days"
Cell J3 is a date in the future manually entered
Cell J5 is the date today generated by =TODAY()
Cell J7 has the above formula which shows weeks and Days between the two dates.
This all works fine until the date in J3 is less than todays date ie yesterdays date or any date in the past.
in which case Cell J7 shows the above error. I would like that cell to display the message "Expired"
Help appreciated. thanks
|