Using If statement in cell based on two adjacent cells

[zoog25]

Hello All,

Here is a question, I have a situation where i have a column "AD" that displays a date. The date listed should be 1 year from the date shown in column "AC", unless "N/A" is noted, then it should list the date for 1 year from column "AB". I really familiar with vba but i don't want to make a complicated coding for something i now i can just do a formula to feed into column AD.

Can someone please show me what i need to do in order to write a proper If statement for this situation.

Thank you.

 

[tyija1995]

Hey assuming you are using row 1 to start with:

AD1:

=IF(AC1="N/A",EDATE(AB1,12),EDATE(AC1,12))

 

[Eric W]

Try:

=IFERROR(EDATE(AC3,12),EDATE(AB3,12))

 

[njimack]

Slightly shorter version...
=EDATE(IFERROR(AC1,AB1),12)

 

[tyija1995]

Slightly shorter version...
=EDATE(IFERROR(AC1,AB1),12)

Nice! Although it would depend if AC1 is actually an error or just the string "N/A" - if it's just a string then this formula returns an error in itself.

 

[zoog25]

Thanks everyone, i'm trying each one out but so far they are all working. Thank you once again.