In excel 2007:
Column E is formatted as date and is the start date.
Column F is formatted as date and is the end date.
Column G is formatted as number and is the cumulative number of days between E and F.
Problem: What is the formula to show the number of days that have passed in G when a date is entered in E, F is blank and will only stop counting when a date is entered in F.
Example: The current date is 11/21/12. E is 11/01/12, F is blank, and G shows 21.
Bookmarks