-2

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

Sajjad Gul
  • 1
  • Hi, your question needs more information. Can you have a look at the help center on ideas of how to improve your question. https://stackoverflow.com/help. Are you wanting to get the week number based on a specified date? `weeknum()` will do the trick. Are you wanting to calculate time between two dates? `datedif()` will do the trick. – gSaenz Jun 22 '20 at 12:12

1 Answers1

0

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.

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
d.zardo
  • 11
  • 2
  • by viewing the example i just want to count the dates mentioned in the data not every date in a week and i also want to count repeated dates as 1 so i can count there are 4 days mentioned in selected week. – Sajjad Gul Jun 22 '20 at 12:58