Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating volume and number.
I'd like to construct a macro that can generate the proper
volume number and number for a publication. Ideally, the user would enter the year in a cell and run a macro that would generate the year's volume/number on another worksheet. The publication has two sets of volumes/numbers. One for the Monday through Saturday (daily) edition and one for the Sunday paper. The anniversary date for the daily paper is 1/26/1880. The anniversary date for the daily paper is 9/13/1981. The volume refers to each year published. The number refers to the days that have been printed in that volume. For example, the Sunday proper volume/number on 2/19/06 would be Volume 26 No. 23. For the daily, the volume/number on 2/21/06 would be Volume 127 No. 23. On Jan. 26, 2007, the Volume for the daily paper would be 128 and the No. would be 1. On Sept. 13, 2006, the Volume for the Sunday paper would be 27 and the No. would be 1. I would also like to add some flexibility to the macro. There are certain holidays the publication does not publish. I would like to have the option of adding certain dates in a column that would give an accurate count. For example in 2005, the publication did not publish 12/25, so I would have entered that date to get the proper number for Sunday. I am using Excel 2000 on XP and NT4. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
calculate/convert volume price to monthly average price | Excel Worksheet Functions | |||
Create a Graph with Random Number Generator | Charts and Charting in Excel | |||
trim a string by specific number of characters | Excel Discussion (Misc queries) |