formula help needed
Posted by Lisa on July 30, 2001 5:28 AM
my spreadsheet needs to automatically calculate the number of days between two dates. i would like to enter the dates over a period of time. if both dates are not available i would like to see "insufficient data" in the cell. as it is now it will display a negative number. How do i get it to show either the number of days between the two dates or insufficient data if there are not two dates to calculate betwee.