lynnnow
05-01-2010, 12:47 AM
Hi,
Please see the attachment.
I've got people with weekly offs on Mondays or Saturdays (I've not posted all the data, but will update the formula with the solution provided). The Sunday weekly offs are not supposed to be counted. This has to be counted from the 21st of the previous month to the 20 of the current month.
Is there a way to check the day of week for a particular row and count the number of WO (Saturday or Monday) in total that are extra?
I've never used an array formula and don't know how to go about it.
Please advise.
Please see the attachment.
I've got people with weekly offs on Mondays or Saturdays (I've not posted all the data, but will update the formula with the solution provided). The Sunday weekly offs are not supposed to be counted. This has to be counted from the 21st of the previous month to the 20 of the current month.
Is there a way to check the day of week for a particular row and count the number of WO (Saturday or Monday) in total that are extra?
I've never used an array formula and don't know how to go about it.
Please advise.