Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Month
Hi All,
I have a bunch of data that I am matching by month. To make my formula work, I need all the dates to be exactly the same, but for example, for November I have data of the 1st, 2nd, 10th etc. I'm using a formula to look up any values that match, for example, Nov-2008. This is of course 01/11/2008, so it dosn't pick up anything between 02/11/2008 and 30/11/2008. How do I make all of the dates like "30/11/2008" to just be Nov-2008? Thanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Month
Hi,
You don't have to do that. Try this A1 B1 10/11/2008 Nov 2008 then the formula =Month(a1)=Month(b1) and you will see it evaluates as TRUE so do your criteria validation like that Mike "Cam1234" wrote: Hi All, I have a bunch of data that I am matching by month. To make my formula work, I need all the dates to be exactly the same, but for example, for November I have data of the 1st, 2nd, 10th etc. I'm using a formula to look up any values that match, for example, Nov-2008. This is of course 01/11/2008, so it dosn't pick up anything between 02/11/2008 and 30/11/2008. How do I make all of the dates like "30/11/2008" to just be Nov-2008? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel to make the days cary over month to month automaticly | New Users to Excel | |||
Excel 2003 month to month data change grid | Excel Discussion (Misc queries) | |||
Subtract a future month from the current month to get remaining m. | Excel Worksheet Functions | |||
When using MONTH function on Blank Cell!! Returns Month=Jan! | Excel Discussion (Misc queries) | |||
transfer cell $ amount to other sheet month-to-month without overc | Excel Discussion (Misc queries) |