Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Matching the month and year portion of a date only
Hi,
I have this formula which checks whether a date (G$1) is in a range and performs a bunch of actions based on whether it is or not. =IF(AND(G$1=data!$K2, G$1<=data!$H2), (IF(TEXT(G$1,"yyyymm")=TEXT(data!$K2,"yyyymm"),$F2 ,data!$I2/data!$G2)),"") The second part starting (IF(TEXT(G$1, "yyymmm" etc is supposed to return a value ($F2) if the month and year part of G$1 and $K2 match. THis is not happening however and for F$2 to be pulled through the day part of the date has to match also. This is not supposed to happen! - i only want to match the month and year! Can anybody help? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
holiday dates | Excel Worksheet Functions | |||
how to insert month date year and day of week | New Users to Excel | |||
how to insert month date year and day of week | Excel Worksheet Functions | |||
Format date with just month and year | Excel Discussion (Misc queries) | |||
Month Year Date Format | Excel Worksheet Functions |