Hello everybody,
I am working with Excel 2007 and Wjndows Vista
I need to calculate the end date, having the start date and workdays. I also have a holidays range.
Before the second of October 2016, Saturday is a working day, after this date, Saturday will be considered as a not working day.
For example
In sheet WORKS
START DATE A1: 07/01/2016
WORKING DAY B1; 30
In sheet HOLIDAYS CALENDAR
Range C8:C23:F8:F11
Range C8:C23 Range F8:F11
C8 01/01/2016
C9 06/01/2016
C10 24/03/2016
C11 25/03/2016
C12 01/05/2016
C13 17/05/2016
C14 24/06/2016
C15 25/07/2016
C16 15/08/2016
C17 12/10/2016
C18 01/11/2016
C19 06/12/2016
C20 08/12/2016
C21
C22
C23
F8 08/02/2016
F0 04/04/2016
F10
F11


I used the following functions: weekday, workday ….., but I do not get the correct answer
I'm struggling with, but I am not be able to sort it out. I am not an expert with Excel


Any help would be appreciated

Cross post without links

http://www.excelguru.ca/forums/showt...s-and-holidays

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Hello everybody,

Thanks for ypur reply.

I must to tell to the forum experts that I made a basic mistake with the use of the forums.I have no experience with them. I did cross-post

I only want to get the correct answer, not pick the best one.

I’m ashamed of myself. Please, accept my apologies. I am so sorry, it will not happen again.

I will follow the suggestion of your link about the use of forums and the cross-post.

Please, see the link about my apologies

http://www.excelguru.ca/forums/showt...s-and-holidays

Kind regards

Better to post a sample sheet so we don't have to recreate yours.