Date Formula Help

[AndrewMac]

Any help here appreciated.

I want to create a formula that will give the the date that is the last business day (i.e. not weekend or bank holiday) which is no more than 60 days from the date in A1.

Many thanks in advance,

Andrew

[teylyn]

Hello Andrew,

maybe something like this:

=WORKDAY(A1,NETWORKDAYS(A1,A1+60))

You need to install the Analysis ToolPak (Tools - Add-ins) for the functions to work.

[DonkeyOte]

Perhaps

=WORKDAY(A1+61,-1)

[teylyn]

Something bugged me about my suggestion. It delivers dates too far in the future. Scratch it.

DonkeyOte's is right, first time.

[AndrewMac]

Thanks DonkeyOte,

How can I incorporate bank holidays in the formula. I have a named range HolidayList.

[AndrewMac]

OK Thanks guys, I've got it now, I think.