Calculate days, but only working days?

[Skyline]

Hi,

I'm trying to set a spreadsheet so that I enter a date in one box, and it give's me 91 days from that date in another, but only counting WORKINGDAYS (So not weekends).

Is this possible? Here is the formula I'm using

=DATE(YEAR(A3),MONTH(A3),DAY(A3)+91)

This works fine for adding on 91 days, but does not take account the working days, so will sometimes return me a Saturday/Sunday... If 91 days fro mnthe date is a Saturday or Sunday, I want it to return with Friday's date...

Thanks.

 

[VoG]

Try

=WORKDAY(A3,91)

which requires the Analysis Toolpak (Tools > Add-ins).