Dear Friend,


after reading your query that you are not including weekend and holidays,

i modified my formula, You just need to update the date which are actually holiday according to your office.




kindly find the attachment...

Attached Files

Target Workbook.xlsx (11.4 KB, 13 views)

Did you look into my last post and at 2 attachments there? In main table is a column Workdays, where the number of working days between 2 dates is calculated (with holidays accounted). And this Workdays value is compared with Target.

Copy your holiday dates into table on sheet Holidays in ether of workbooks I provided (I entered some dummy dates into this table to avoid formulas returning some error). That's all. From there you can carry on.

Dear Friend,

Do you find any error in my formula?
Kindly check and let me know if it is not ok.

The formula is OK. But holiday list may be truncated to 2 top entries (or corrected) - one holiday is repeated 13 times!

13 repeated will be filled by LynnMac2016

Guys,

I cannot thank you enough - all 3 examples make total sense and more importantly - work!

This has assisted me greatly and also my understanding of Excel further!

Happy days!

Lynn