Assume the number of tickets sold is in A1, and in D1 you have the
reference date (1st July 2007) in Excel date format. This formula will
give you the number sold per day:

=A1/(TODAY()-D1)

If you take it that an average month is 30 days, then multiply by 30
to get the monthly rate.

Hope this helps.

Pete

On Oct 9, 4:44 pm, Brian wrote:
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