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...
- Thank you for the response.
But there is more in a category.
Ex. I want "NA" for Officer & Foreman, then Edate formula on Staff & FO.
Please suggest me formula for this.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.
- Thank you so much for such a quick response. I was stuck & exhausted on this. you relived me.👌👍
