Forum

Notifications
Clear all

Workday Function

2 Posts
2 Users
0 Reactions
70 Views
(@hanson2)
Posts: 1
New Member
Topic starter
 

Please I need assistant, I am new to this site and struggling with a serious challenge.

 I work on a project where we trying to de-congest the ARVs medication collection process.

Every day we receive many people who come to collect medication. We are struggling with estimating when they should come for their next collection which is after three months. Taking into account that fact that public holidays and Sunday the facility is closed. (we give them medication for every day included Sunday, holidays but they cannot collect on these days)

Example For the month of June 2018

 Start date 2018-06-01     To 2018-09-01 (3 months period) Come 3days before expiration)

 

Problem: I want to calculate next collection date excluding Sundays and Public holidays only for the entire month of June 2018 (making sure the date does not fall on a Sunday or on a public holidays?

To ensure they come 3 days before their medication finishes.  If you collect 1st June when is next collection and apply to the 30th of June

I have a list of public holidays for 2018.

 

I was using the workday and networkday int

 Thank you

 
Posted : 07/06/2018 11:23 am
(@sunnykow)
Posts: 1417
Noble Member
 

Hi Hanson

Please refer attachment.

I am calculating for 3 months (3 days before expiration)

It should work for any date.

Hope this helps

Sunny

 
Posted : 07/06/2018 10:54 pm
Share: