date difference in mm/yyyy format
The problem with this formula is it doesn't support dates which are in
different years. Dave's is a better solution.
Regards,
Fred
"Roger Govier" wrote in message
...
Hi Ian
=if(Month(readdate)<month(startdate),"yes","no")
--
Regards
Roger Govier
Ian wrote:
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?
|