IF and IFERROR together (Sharepoint)

[Sunshine8790]

I have an excel sharepoint file so I am not able to post my ranges with XL2BB as I normally would for excel help.

This is the screenshot of the area I'm looking to fix (Columns J and K):
All 3 columns are filled with formulas.

Column I formula:

=IFERROR(VLOOKUP(A2,'Emp Summary'!A:AP,42,FALSE),"inactive")

Column J formula:

=IF(I2="","",MONTH(I2))

Column K forumula:

=IF(I2="","",DAY(I2))

What I need is a fix for the formulas in J and K. I want to add the IFERROR function to tell it that if there is no date, to return as "inactive".

Anybody?

 

[RobP]

assuming I formula is working, would you not use something like

=IF(I2="inactive","inactive",MONTH(I2))

 

[Sunshine8790]

assuming I formula is working, would you not use something like

=IF(I2="inactive","inactive",MONTH(I2))

THANK YOU!!!!

 

[RobP]

you're welcome.. thanks for the feedback
Rob