| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Matching month part of date only
RGB, The problem is the MONTH formula will not always be true for the months in the preceeding years. You can use the day part of the date (make excel change the day to the first since the actual date is not important just the month). =IF(AND(C1=DATE(YEAR($A$2),MONTH($A$2),1),C1<=DAT E(YEAR($B$2),MONTH($B$2),1)),"yes","no") This makes the date in A2 to = the 1st of July 2006 and in B2 the 1st of August 2007. HTH Steve -- SteveG ------------------------------------------------------------------------ SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571 View this thread: http://www.excelforum.com/showthread...hreadid=561559 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date of the First day of the previous month | Excel Discussion (Misc queries) | |||
| Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
| GETTING MONTH FROM A DATE | Excel Discussion (Misc queries) | |||
| HELP with this function | Excel Worksheet Functions | |||
| Lookup the month in a date string 01/03/05 | Excel Worksheet Functions | |||
Hybrid Mode
