Forum Discussion
Solved
Excel Formula
Greetings of the day, Example. I have a category in data like officer & staff. in which I want to show the training due date by using the Edate formula. but where an officer is there, there should...
Kasafkhan Same principle but add the OR function and perhaps wiser to check for the ones that don't need training.
=IF(OR(A1="Officer",A1="Foreman"),"NA", EDATE(-----------))
Thank you, sir.it works very well.
but can you please suggest, if I want to remove that default date "30-dec-1904" from a blank cell, where a date is not available.
but can you please suggest, if I want to remove that default date "30-dec-1904" from a blank cell, where a date is not available.
Kasafkhan Perhaps better to show the complete picture in one go, rather than adding small pieces to the problem. what do you mean by "that default date of 30-dec-1904"?