If date is between two dates copy row to another sheet.

Hi. I need a formula that will check if any values in column "C" on the "Payments" sheet are within the two dates specified by the variables "sDate" which is the start date and "sEnddate' which is the end date. The dates will only be month to month, so if sDate = 01/02/2012 then sEnddate would be = 29/02/2012.

Dates in the "C" column of the "Payments" sheet are stored as full dates, eg. 13/02/2012.

If any of those dates are between the ones specified they the entire row that they're on needs to be copied to the "Compare" sheet, with data being inputted on that sheet starting at Row 2.

Thanks in advance.

Possibly...

Please Login or Register  to view this content.

Originally Posted by dangelor

Possibly...

Please Login or Register  to view this content.

I get a
Screen Shot 2012-05-21 at 11.36.43 AM.png

Try this (added a missing period)...

Please Login or Register  to view this content.