Kindly note that the start and the end dates are also in a range of cells in
sheet1

"Bharat Saboo" wrote:

I have a start date and end date
I need to check if the month and year fall within the range

Start Date & End Date are in sheet 1
Date to check is in sheet 2

Depending on the above condition, if true, I need to sum

Kindly suggest ways as I am at a loss to understand how to do it.

Thanks