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 the number of years published. The number
refers to the days thus far in that volume that have been printed.
So, 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.
Thanks for any help.