I need to create a formula that will automatically calculate the number of
tickets sold per month that takes into account the current date. The number
of tickets sold since July 1, 2007 is in a cell which is continuoslu updated.
As of today, October 9th, we have sold 5251 tickets which will result in
around 1595 tickets per month. But this sure has me stumped, any ideas?
--
Brian