if between dates

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a column of dates. I wish to create another column that tells me if
the date in the column falls within a range and if so to make a change or
not. For example
a b
10/3/2007 change
10/1/2005 no change
My formula =if(and(a1>10/1/2007,a1<10/1/2008),"Change","No Change") tells me
everything is "no change"
Could someone please tell me what I am doing wrong?
Thanks for your help.
 
Kevin,
That was perfect, thank you so much.

Kevin B said:
Change your if statement as illustrated below so that the date values are
treated as dates:

=IF(AND(A1>DATE(2007,10,1),A1<DATE(2008,10,1)),"Yes","No")

The syntax of the DATE Function is DATE(Year,Month,Day)

All the arguments require an integer entry.
Click to expand...
 
Back
Top