date difference in mm/yyyy format

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

Dave Peterson

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")
 
F

Fred Smith

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

Ian

only works if it's the same year?

what if the dates are Dec 31, 2008 and Jan 1, 2009?
 
R

Roger Govier

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA - exporting serial letters to single documents 0
How to add day to PWA 2016 date format? 0
Forcing a date entry format of dd/mm/yyyy 1
Returning the month (mmm) from cell in date format dd/mm/yyyy 3
Date Formats 4
is it possible to sort by approximate date? 2
How to enter a date in DD-MM-YYYY format 2
Help with date format mm/dd/yyyy vs. dd/mm/yyyy 3

Top