Try..
=IF(M2=datecell-DATE(1,0,0),"Yes","No")

--
Jacob (MVP - Excel)


"Dave" wrote:

Hi, I want to be able to count between a date range and return the value yes.
I will show you the formula I currently have:

=IF(M2=DateCell-365,"Yes","No")

This gives a yes if the date is greater than the date in M2 minus 365. This
however cincludes all the dates beyond M2 which isnt what I want. I want the
dates upto M2. If that makes sense? Any help would be greatly appreciated

Thanks