YKBYKB

Great, thank you for your prompt response. I've been testing these 2 calculations and i found that there is a problem if the start date is 1/11/2014 and end date is 30/11/2014. November 2014 is 30 days with 9 Fridays and Saturdays which means that regular days should be 21 and weekend days should be 9. With the above calculations I get 20 and 10 respectively. I also tried having the start and end dates as Saturday the 6th of December 2014 to see what the outcome would be. I expected to get regular days 0 and weekend days 1. However I got -1 regular days and 2 for weekends. Am I missing something or doing something wrong?

Can you please explain what is "O"? I don't understand that line "o = Case ( r ; ( d + r > 6 ) + ( d + r > 7 ) )". I am trying to work with this calculation to calculate different work rota patterns for a 4, 8hr shifts, (24/7) operation. I'm going for a calculation that determines if a person who is currently on crew A for example is on a working day or a weekend, while considering that these weekends change every work week depending on Crews B,C and D. Your help will be very much appreciated.

I work in an an industrial envirnoment where PLC is used to control all the machinery. From the PLC output we get all the production delay times and so on in order to make sure that this information is correct (bonuses paid are based on minimising production delays). Now we were discussing if we should use FM to store production data and generate daily performance reports automatically and we were stuck at "can FM recieve data from a PLC program directly?". If anybody has a similar experience It would be much appreciated if they share Many Thanks.

Thank you very much guys, I got the function working great now and I added the holidays feature that was mentioned in the FM help post as well. Thanks a million :)

I am afraid, I still do not quite understand that string. You explained that it is the 49 combinations of start and end dates. Did you mean the combinations of start and end dates of any week in a calendar year? If so, how would the day off be represented differently to the work days in this matrix? How I understand it at the moment is that the numbers, represent the day of the week, sunday being 0, Mon=1, Tue=2...upto Sat=6. And if that was correct, then the first combination in the original string (0012345) doesn't make sense to me because sunday and monday are represented by a 0. I also tried to work backwards using the 1st line you provided and relating 0123455 of a 6 day week with fridays off to 0012345 for sat-sun off, to understand how to build the rest of the string but I could not. I'm still lost, please help Many Thanks.

Thank you so much for taking the time to help me! Really appreciated I will try and workout the right string for my case and post it back here incase someone else needs it oneday and also for you to point out any mistakes I might make Many thanks again :)

Dear All, I was reading what's on the forums for a calculation that can be used to workout the number of weekdays between 2 dates. My problem is that the only day off i have in the week is friday. Can you advice me how to modify the calculation below to work with 6 day work weeks with fridays off rather than saturday and sunday? It would also be greatly appreciated if someone can desifer this number string for me, 0012345501234544012343340123223401111234010012340, what does it mean? Many thanks for your time and help 5 * Int ( ( EndDate - StartDate ) / 7 ) +Middle ( "0012345501234544012343340123223401111234010012340" ; 7 * (DayOfWeek ( StartDate ) - 1 ) + DayOfWeek ( EndDate ) ; 1 )