Forum Discussion

Copper Contributor

Jun 12, 2022

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...

excel

Riny_van_Eekelen
Jun 12, 2022
Kasafkhan
That could be something like:
=IF(A1="Staff", EDATE(------------),"NA")

Riny_van_Eekelen

Platinum Contributor

Jun 12, 2022

Kasafkhan

That could be something like:

=IF(A1="Staff", EDATE(------------),"NA")

Kasafkhan

Copper Contributor

Jun 12, 2022

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.

Riny_van_Eekelen
Platinum Contributor
Jun 12, 2022
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(-----------))
- Kasafkhan
  Copper Contributor
  Jun 12, 2022
  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.
  - Riny_van_Eekelen
    Platinum Contributor
    Jun 13, 2022
    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"?