date difference in mm/yyyy format

  • Thread starter Thread starter Ian
  • Start date Start date
I

Ian

I have two date colums
StartDate
ReadDate

I want to find all the readdates that are in months prior to the startdate

Eg if(readdate<startdate,"yes","no")

the problem is that if the readdate is in the same month (or any later date)
as the startdate I want a "no' returned. Is there any way to compare to
dates in a mm/yyyy format?
 
If you entered the values as real dates (a month, a day and a year) and
formatted the cell to show mm/yyyy, then you could use:

=if(text(a1,"yyyymm")<text(b1,"yyyymm"),"yes","no")
 
The problem with this formula is it doesn't support dates which are in
different years. Dave's is a better solution.

Regards,
Fred
 
I quite agree!!
--
Regards
Roger Govier

Fred said:
The problem with this formula is it doesn't support dates which are in
different years. Dave's is a better solution.

Regards,
Fred
Click to expand...
 
Back
Top