"IF" Question?

L

Lime

Any help is greatly appreciated..

I have a column with different dates in it. I need to find the dates that
fall in the month of Aug 2009.

here's what I have
=IF(G2>=08/01/2009 and <=08/31/2009, "Y","N")
 
G

Glenn

Lime said:
Any help is greatly appreciated..

I have a column with different dates in it. I need to find the dates that
fall in the month of Aug 2009.

here's what I have
=IF(G2>=08/01/2009 and <=08/31/2009, "Y","N")
Click to expand...


=IF(AND(G2>=--"08/01/2009",G2<=--"08/31/2009"),"Y","N")
 

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

Calculate within a time range with only start date and end date 2
Simple IF problem 7
SUMPRODUCT Between Dates 7
order of opening files with sumproduct returning #REF! 2
possible countif formula? 3
XIRR Function - large IRRs 1
If statements?? 2
How do I get Excel to display which financial year a date is in? 6

Top