How to check date whether it is holiday or weekend and then get TAT

[Ratan Bhushan]

Hi Team

I am making a tracker in which I have stucked on a very tricky part where I need to get the dates.

There is a column "Date Request Raised" which can be any date of the year.
here we need to check whether date is weekend or not falling in the holiday list.
or both.
then how can we check this or can get the next date.

I am stucking where how to check if next date of the holiday or weekend is holiday or not.

Please help.

I have attached the sample file.

Thanks
RatanB

 

[NARAYANK991]

Hi ,

If you use the NETWORKDAYS function as follows :

=NETWORKDAYS(DateToBeChecked , DateToBeChecked , HolidaysList)

then if DateToBeChecked is either a weekend or in the Holidays List , the above formula will return 0 , else it will return 1.

Narayan

 

[shrivallabha]

Ratan Bhushan,

1. Your posted spreadsheet doesn't contain the column "Date Request Raised".

2. You have also worked on IsWeekend VBA function which looks in line with basic logic posted above.

Can you tell what difficulty you are facing with VBA part? Narayan's formula logic can be implemented in VBA as you've already done for VLOOKUP portion.