Quote:
Originally Posted by Shashi Kant
after reading your query that you are not including weekend and holidays.
|
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.
Quote:
Originally Posted by Shashi Kant
i modified my formula, You just need to update the date which are actually holiday according to your office.
|
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.