Hi
I'm trying to do a formula that will calculate the difference between two dates. I have managed to do this but when there is a date missing it is creating a huge number. How do I put an exception in that it returns either a zero or something when a date is missing. I've attached a sample of what I'm doing, hope someone can help. For Forum.xls
Bookmarks