Find the start date from end date and date range and exclude weekends

Hello,

I wanted to find the start date based on the end date and make sure to exclude the weekends. Does anyone know what formula can help you achieve the result?

For example,

If I put the start date as 02/15/2017 and want to go back 283 working days excluding weekends and holidays, the result should be 01/04/2016.

What are the holiday dates?

Originally Posted by JohnTopley

What are the holiday dates?

I have listed all the holidays from 2016 to 2018 in the attached. please help me find the formula.

Try

=WORKDAY.INTL(D5+1,-D2,1,A2:A26)

+1 to allow for inclusive days.

MOTE: error in one date 29/02/2018 should be 28/02/2018

Originally Posted by JohnTopley

Try

=WORKDAY.INTL(D5+1,-D2,1,A2:A26)

+1 to allow for inclusive days.

MOTE: error in one date 29/02/2018 should be 28/02/2018

I tried the suggested formula and it came out as an error.

Originally Posted by Tony Valko

What error?

The result showed #VALUE! . Perhaps you can attached the sample workbook for me.

Originally Posted by AlKey

Try this

Formula:

Please Login or Register  to view this content.

Thanks. It works.

NOTE: error in one date 29/02/2018 should be 28/02/2018

.... as I pointed out ..... this is the reason for your error.