Jun 12 2022 02:13 AM
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 be shows "NA" & if there is staff in the category I want to run the Edate formula.
Please suggest ways to to do it.
Jun 12 2022 02:26 AM
SolutionJun 12 2022 03:21 AM
Jun 12 2022 03:49 AM
Jun 12 2022 04:08 AM
@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(-----------))
Jun 12 2022 08:02 AM
Jun 12 2022 09:20 PM
@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"?
Jun 12 2022 02:26 AM
SolutionThat could be something like:
=IF(A1="Staff", EDATE(------------),"NA")