| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
date difference in mm/yyyy format
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
date difference in mm/yyyy format
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
date difference in 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" ) 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? -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
date difference in mm/yyyy format
only works if it's the same year?
what if the dates are Dec 31, 2008 and Jan 1, 2009? "Roger Govier" wrote: 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? . |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
date difference in mm/yyyy format
I quite agree!!
-- Regards Roger Govier Fred Smith wrote: 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? |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
date difference in mm/yyyy format
As I said, Dave's solution is better.
Regards, Fred "Ian" wrote in message ... only works if it's the same year? what if the dates are Dec 31, 2008 and Jan 1, 2009? "Roger Govier" wrote: 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? . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Format date dd.mm.yyyy to dd/mm/yyyy | Excel Discussion (Misc queries) | |||
| change date format from dd/mm/yyyy to mm/yyyy | Excel Discussion (Misc queries) | |||
| change date format dd/mm/yyyy to Julian date format? | Excel Worksheet Functions | |||
| Help with date format mm/dd/yyyy vs. dd/mm/yyyy | Excel Discussion (Misc queries) | |||
| how do I change date from mm/dd/yyyy to dd:mm:yyyy format in Excel | New Users to Excel | |||
Linear Mode
