Thread: date difference in mm/yyyy format
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default date difference in mm/yyyy format
=IF(A1-DAY(A1)<B1-DAY(B1),"yes","no")


"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?


Reply With QuoteReply With Quote