Yes, you are. But whether or not it is a good way to project year-end
revenue depends on the nature of the business. Usually not. Oh well, "give
the customer what he wants".... :-)
Assume that "cell1" is A1, with the YTD revenue. And assume that A2
contains the date of the YTD revenue in A1. Then put the following into
Note: You could replace
do not want to account for the potential leap day.
You could replace "1+A2" or just A2 with TODAY() if you always project
revenue on, respectively, the day after or the day of the date corresponding
to the YTD revenue.
----- original message -----