98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » IFERROR
IFERROR
Resolved · Urgent Priority · Version 2010
Fri 1 Aug 2014, 15:31Delegate Karen said...
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
Fri 1 Aug 2014, 16:23Trainer Cindy said...
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
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Move data worksheet to worksheetTo move data from one worksheet to another, highlight the data. |
