date range comparision on a criteria

T

TUNGANA KURMA RAJU

I have a date range in A1:A10 dates of holidays
another range B1:C20 contains names of employess and their weekly off day.
my task is:
find any date in A1:A1o falls in the current month
count these dates and find corresponding weekdays.
match these weekdays with B1:c20 range and nullify those matching days from
employess holiday count for the current month.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count the remaining weekdays in a data range excluding holidays and start/end dates 5
macro for a range 0
Check dates against a date range. 0
Show value from one cell in another cell if today falls between a date range 5
Compare an Array to a Date Range 9
how to compare a date range another range 3
Counting in between a date range with conditions 2
Date VBA Lookup 1

Top