Sunshine8790
Board Regular
- Joined
- Jun 1, 2021
- Messages
- 71
- Office Version
- 365
- Platform
- Windows
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:
Column J formula:
Column K forumula:
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?
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:
Excel Formula:
=IFERROR(VLOOKUP(A2,'Emp Summary'!A:AP,42,FALSE),"inactive")
Column J formula:
Excel Formula:
=IF(I2="","",MONTH(I2))
Column K forumula:
Excel Formula:
=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?