Weekdays

Hi ,

I'm hoping someone will be kind enough to help me with the below.

I have a forumla in my spreadsheet for a series of dates which is - =SUM(AB6-65)+IF(WEEKDAY(SUM(AB6-65),2)>5,5-WEEKDAY(SUM(AB6-65),2),0)

This at the moment does is if the date is going to land on weekend it moves the date to a weekday. i.e the Friday before.

However i now need to Change this and not sure how .The -65 bit in the formula is based on a Milestone , however i need this to be -65 Weekdays i.e Mon - Fri .

Not sure what i need to do .

Please Help .

Thank you

Apologies where would i include this into the forumla ?

that works a treat .

Thank You Very Much