SOLVED

Excel Formula

%3CLINGO-SUB%20id%3D%22lingo-sub-3496930%22%20slang%3D%22en-US%22%3EExcel%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3496930%22%20slang%3D%22en-US%22%3E%3CP%3EGreetings%20of%20the%20day%2C%3C%2FP%3E%3CP%3EExample.%3C%2FP%3E%3CP%3EI%20have%20a%20category%20in%20data%20like%20officer%26nbsp%3B%20%26amp%3B%20staff.%20in%20which%20I%20want%20to%20show%20the%20training%20due%20date%20by%20using%20the%20Edate%20formula.%20but%20where%20an%20officer%20is%20there%2C%20there%20should%20be%20shows%20%22NA%22%20%26amp%3B%20if%20there%20is%20staff%20in%20the%20category%20I%20want%20to%20run%20the%20Edate%20formula.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20suggest%20ways%20to%20to%20do%20it.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3496930%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3496964%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3496964%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1421554%22%20target%3D%22_blank%22%3E%40Kasafkhan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThat%20could%20be%20something%20like%3A%3C%2FP%3E%3CP%3E%3DIF(A1%3D%22Staff%22%2C%20EDATE(------------)%2C%22NA%22)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3497001%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3497001%22%20slang%3D%22en-US%22%3EThank%20you%20so%20much%20for%20such%20a%20quick%20response.%20I%20was%20stuck%20%26amp%3B%20exhausted%20on%20this.%20you%20relived%20me.%3Aok_hand%3A%3Athumbs_up%3A%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3497101%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3497101%22%20slang%3D%22en-US%22%3EThank%20you%20for%20the%20response.%3CBR%20%2F%3EBut%20there%20is%20more%20in%20a%20category.%3CBR%20%2F%3EEx.%20I%20want%20%22NA%22%20for%20Officer%20%26amp%3B%20Foreman%2C%20then%20Edate%20formula%20on%20Staff%20%26amp%3B%20FO.%3CBR%20%2F%3EPlease%20suggest%20me%20formula%20for%20this.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3497137%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3497137%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1421554%22%20target%3D%22_blank%22%3E%40Kasafkhan%3C%2FA%3E%26nbsp%3BSame%20principle%20but%20add%20the%20OR%20function%20and%20perhaps%20wiser%20to%20check%20for%20the%20ones%20that%20don't%20need%20training.%3C%2FP%3E%3CP%3E%3DIF(OR(A1%3D%22Officer%22%2CA1%3D%22Foreman%22)%2C%22NA%22%2C%20EDATE(-----------))%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3497403%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3497403%22%20slang%3D%22en-US%22%3EThank%20you%2C%20sir.it%20works%20very%20well.%3CBR%20%2F%3Ebut%20can%20you%20please%20suggest%2C%20if%20I%20want%20to%20remove%20that%20default%20date%20%2230-dec-1904%22%20from%20a%20blank%20cell%2C%20where%20a%20date%20is%20not%20available.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3498303%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3498303%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1421554%22%20target%3D%22_blank%22%3E%40Kasafkhan%3C%2FA%3E%26nbsp%3BPerhaps%20better%20to%20show%20the%20complete%20picture%20in%20one%20go%2C%20rather%20than%20adding%20small%20pieces%20to%20the%20problem.%20what%20do%20you%20mean%20by%20%22that%20default%20date%20of%2030-dec-1904%22%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3518834%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3518834%22%20slang%3D%22en-US%22%3EHi!%20Pls%20check%20my%20question%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel%2Fplease-help-me-with-formula-in-excel%2Fm-p%2F3518804%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel%2Fplease-help-me-with-formula-in-excel%2Fm-p%2F3518804%3C%2FA%3E%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

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.

6 Replies
best response confirmed by Kasafkhan (Occasional Contributor)
Solution

@Kasafkhan 

That could be something like:

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

Thank you so much for such a quick response. I was stuck & exhausted on this. you relived me.
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.

@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"?