How to IF function to return date if True, 0 if False

Giganews Newsgroups
Subject: How to IF function to return date if True, 0 if False
Posted by:  Laura M (lcmerr…@louisville.edu)
Date: Fri, 10 Oct 2003

I am working on a spreadsheet where I need to determine
the number of days from Date1 to Date2.  If there is not a
Date2, I want Excel to return a value of 0.  Does anyone
know how to do this?

Replies