| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
today as a function of the year to date
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| MAX figure within a date range as a function of today()'s date | Excel Worksheet Functions | |||
| Using TODAY function to return a date as text | Excel Discussion (Misc queries) | |||
| SUMIF within date range as a function of today()'s date | Excel Worksheet Functions | |||
| =TODAY() function to fix the date | Excel Discussion (Misc queries) | |||
| Today() or Date() function help | Excel Discussion (Misc queries) | |||
Threaded Mode
