count repeated date as one in excel

64 Views Asked by At

i want to count working days in a week by mentioned dates only like in picture only 4 working days will be considered in filtered data "year, month, and Week are derived by induction date column.Example

1

There are 1 best solutions below

1
d.zardo On

Do want that repeated dates are considered into the counting or not? Anyway, you could apply workday formula (=WORKDAY (start_date, days, [holidays])) in an additional column and count from there, adding or criteria with IF formula or other logic to exclude repeated dates if you do not want to consider them.