Notifications
Clear all
General Excel Questions & Answers
4
Posts
2
Users
0
Reactions
848
Views
Topic starter
Good evening. I have a spreadsheet for determining the due date for a police check to be done. The formula I'm using is =EDATE(C34,35). There are a few - for example a staff member on maternity leave where C34 = maternity leave rather than a date. How can I make this a blank rather than an error?
Thanks for any assistance.
Posted : 01/10/2020 4:36 am
Hi Sue,
wrap it in IFERROR e.g.
=IFERROR(EDATE(C34,35),"")
Regards
Phil
Posted : 01/10/2020 5:49 am
Topic starter
Thanks Phil
I had tried to do that, couldn't figure how the formula should be. Greatly appreciated.
Regards
Sue
Posted : 01/10/2020 8:57 am
You're welcome
Posted : 01/10/2020 9:10 am