PERPETUAL CALENDAR

  • Thread starter Thread starter Disperso
  • Start date Start date
D

Disperso

hi
i want to use a perpetual calendar on my macro for calculate, example, the
work days of some years.
Someone can send me an example?

thanks
 
There's an =Networkdays() function that may help you.

Take a look in excel's help for more details. You do have to have the analysis
toolpak addin loaded, though. If you get a #name? error, you don't have it
loaded.

Excel's help describe how to turn it on.
 
function!
really thanks

Dave Peterson said:
There's an =Networkdays() function that may help you.

Take a look in excel's help for more details. You do have to have the analysis
toolpak addin loaded, though. If you get a #name? error, you don't have it
loaded.

Excel's help describe how to turn it on.
Click to expand...
 
I don't believe VBA has a specific Workday function but you should b
able to use the worksheet function:

=WORDAY(start_date, days, holiday)

by calling it through the Aplpication.WorksheetFunction command:


TheDayYouWant = Application.WorksheetFunction.WORKDAY( variable1
variable2, variable3)

Also, attached is a sheet with a perpetual calendar chart. It can b
readily adapted to calculations. It contains no VBA code itself.


Corundu

Attachment filename: calendarchart.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=69367
 
Back
Top