Forum

Algorithm to Calcul...
 
Notifications
Clear all

Algorithm to Calculate Workdays and Import in Outlook Calendar

2 Posts
2 Users
0 Reactions
167 Views
(@sagoma)
Posts: 1
New Member
Topic starter
 

Hi there, 

I'd like to add in our Microsoft Outlook calendars (mostly for Finance people) our Working Days, with the aim of providing better visibility for a better planning - the final outcome would look like the below screenshot:

I have found a page: https://andreilungu.com/workdays-excel-vba-algorithm-outlook-calendar-import/  which covers this (includes VBA for download too - here attached free of virus).

Would anyone in the forum have created this type of VBA better written and more flexible thereby allowing all sort of modifications, ie. I would like to have more than one fiscal year, change the Work Days parameters (in this case excluding WD-15 which isn't necessary). If someone has done something similar that could be reused and can share that would be much appreciated. 

Thanks a lot for your support here.

Bes regards,

Samuel

 
Posted : 13/05/2021 12:09 am
(@catalinb)
Posts: 1937
Member Admin
 

I'm afraid there are very few people with this need.

If you need more than 1 fiscal year, I guess you'll need to run the code for each year separately to create the outlook entries.

 
Posted : 16/05/2021 11:55 pm
Share: