Excel Formula that factors in dates in calculating revenue
Posted on 2010-08-26
I need a Microsoft Excel formula that will help me calculate revenue based on a date. For example, I will have a date, say 5/21/2010, and I need to account for all days following this date until the end of the year (so, from 5/21 to 12/31) -- need to get a total count of days, like 180.
Need a date formula that will calculate this.