Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
compare month and year in a date
I have 2 date columns and i need to compare the month and year only,
for example: column a = 31/12/2009 and column 2 is 12/12/2009, the result should be true -- Afia |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
compare month and year in a date
On Fri, 7 Aug 2009 04:25:01 -0700, Afia wrote:
I have 2 date columns and i need to compare the month and year only, for example: column a = 31/12/2009 and column 2 is 12/12/2009, the result should be true =and(month(a1)=month(b1),year(a1)=year(b1)) or, less intuitive but shorter: =(a1-day(a1))=(b1-day(b1)) --ron |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
compare month and year in a date
Another:
=text(a1,"yyyymm")=text(b1,"yyyymm") Afia wrote: I have 2 date columns and i need to compare the month and year only, for example: column a = 31/12/2009 and column 2 is 12/12/2009, the result should be true -- Afia -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
compare month and year in a date
Ron, Dave
Thank you!!! -- Afia "Dave Peterson" wrote: Another: =text(a1,"yyyymm")=text(b1,"yyyymm") Afia wrote: I have 2 date columns and i need to compare the month and year only, for example: column a = 31/12/2009 and column 2 is 12/12/2009, the result should be true -- Afia -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
count month when date is in day/month/year format | Excel Worksheet Functions | |||
Tell me which "season" (Month/Day through Month/Day) a date(Month/Day/Year) falls in (any year)??? | Excel Discussion (Misc queries) | |||
bar chart to compare month and year data | Charts and Charting in Excel | |||
How to compare a date with financial year | Excel Discussion (Misc queries) | |||
Sort month/date/year data using month and date only | Excel Discussion (Misc queries) |