| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Determine if a month falls between two dates.
Hello, I have been tasked with trying to do the following
Column A - Date column B -Date A will always be earlier than B columns C-N will be labeled months Jan-Dec What I need to do is determine if the date between column A and B includes the given month in column C - N and return a value of X. ie... A B C D E F Jan Feb Mar Apr 1/1/10 3/12/10 X X X blank I can then count the X values. Any help would be greatly appreciated. -- Thank you for your assistance! Rob |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula to determine whether a date falls between two dates | Excel Discussion (Misc queries) | |||
| formual to determine if date falls on weekend, adjust date to Mond | Excel Discussion (Misc queries) | |||
| Tell me which "season" (Month/Day through Month/Day) a date(Month/Day/Year) falls in (any year)??? | Excel Discussion (Misc queries) | |||
| count no. of dates in a column that falls on certain month & year | Excel Worksheet Functions | |||
| Formula to determine whether number falls within range?? | Excel Worksheet Functions | |||
Threaded Mode
