Forum Discussion
#NUM! error - how do I make it Zero?
I have a document where I need to work out the difference between two dates. this will be duplicated up to 1000 times, and needs to be dynamic for adding different dates in. but I am getting a NUM ...
You could use:
=IFERROR(DATEDIF(W6,X6,"y"),0)
=IFERROR(DATEDIF(W6,X6,"y"),0)
- many thanks for your help, much appreciated
- You're welcome!
