Extract first date from specific period counting working days only

[nicoan]

Hello all

Please take a look at the calendar date attached:
CALENDAR.xlsx

In short we need to extract the first working date from the last periods. We have already identified the working days and marked them as 1.
So we just need to count them backwards to get the first date of each period.

For example:
If the "FullDate" in a row is 05-02-2010 and we want to fill the "First Date Prev. 1 Month", we need to count -22 working days from 05-02-2010 and the resulting date would be "06-01-2010".

I highly appreciate your help.
Thanks in advance.

[rcm]

this should work

[nicoan]

Hi rcm

Thanks so much.
Sorry, itīs working perfectly.

Thanks a million.