jessebh2003
Board Regular
- Joined
- Feb 28, 2020
- Messages
- 71
- Office Version
- 365
- Platform
- Windows
Hello! I'm writing a formula that if the cell to the left is blank or text will make the formula cell blank, otherwise if the cell to the left is numbers the nested formula will execute. I'm sure I'm missing something but can't figure out what. Appreciate any help! Thanks.
This is my current formula in F2.
Here's what I've tried, which doesn't work.
This is my current formula in F2.
Excel Formula:
=IFERROR(DATE(YEAR(E2)+3,MONTH(E2),DAY(E2)),"")
Here's what I've tried, which doesn't work.
Excel Formula:
=IF(ISERROR(OR(ISBLANK(E2),"",(DATE(YEAR(E2)+3,MONTH(E101),DAY(E2)),"")