Karen has attended:
Excel Intermediate course
Excel Advanced course
Presentation Skills course
IFERROR
I am adding 10 years to the dates in column P. Where there is no date, a random date of 31/12/1909 comes up. Is there a way please to change the format so that if there is no date in column P, the date in column Q stays blank too?
I have the following formula in column Q
=DATE(YEAR(P2)+Sheet1!$A$1,MONTH(Report1!P2),DAY(Report1!P2))
I have tried to put in
=IF(P1=""(DATE(YEAR(P2)+Sheet1!$A$1,MONTH(Report1!P2),DAY(Report1!P2)),""
...but this doesn't work?
Thanks,
Karen
RE: IFERROR
Hello Karen,
Thank you for your question.
I think a few small tweaks to the formula you already have is all that's required (fingers crossed).
Try this
=IF(P1="","",DATE(YEAR(P1)+10,MONTH(P1),DAY(P1)))
If this doesn't correct the issue, please get back in contact and we'll try again.
Kind regards
Cindy
Microsoft Office Trainer
