Probably lost here...Can you post back with samples and the expected results...
--
Jacob (MVP - Excel)


"Dave" wrote:

Hi

This does not work. It counts a year back plus one month and gives a yes to
dates beyond the date in M2. So it doesnt work. I have tried to manipulate it
but to no avail!?

Thanks

"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