Excel 2007 : date range selection help please

[Gary Evans]

I have a large spreadsheet with a date in column G for each name. I need to identify cells where the content is between 1-Dec-2011 and 31-Mar-2012.

Can anyone help me with a formula please.

[tuph]

I suggest entering your start and end dates into cells for easy reference. So if you put the start date in A1 and the end date in B1, a formula like this might work.

=IF(AND(G1>=A1,G1<=B1),[then whatever],[whatever else])

[Gary Evans]

Thank you for your prompt response. I have ended up using filters because I found out that the year was irrelevant, it was the day and month that was of interest.