Time range to workdays in relevant months
using Networkdays function isn't problem. My problem is presentation of
results to simple calendar. As I wrote on exaple "I need"
PLS, do you have some ideas?
Thanks
Tom Ogilvy pÃ*Å¡e:
You can use the NetWorkdays function from the analysis toolpak - Demo'd from
the immediate window:
? application.Run("ATPVBAEN.XLa!NetWorkdays" ,DateValue("May 4,
2006"),DateValue("May 31, 2006"))
20
Or just use the formula on your worksheet.
--
Regards,
Tom Ogilvy
"Lukino" wrote:
Hello,
I really need to fill relevant workdays to cells represents relevant months
from only StartDay and FinishDay.
I know (example):
StartDay FinishDay
4.5.2006 11.7.2006
I need (example):
April May June July August
0 20 22 7 0
PLS, help me
Thanks a lot
Lukas
|