Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Good morning,
My brain is in drain mode today, so I am asking for your expert help. Spreadsheet : Column F contains dates in each row - dates vary from any date in 2009 to any date in 2011. Column U ~ BO Header row contains dates to the first of each month ( U = 09/11, W = 09/12, X = 1/10 ) formated to show m/y. I have played with the IF - statement, but I'm not getting what I need. I would like to have the cell under each m/y to place that date in, IF it falls within that month/year... or IF it falls between the m/y of the column to the left and the column to the right - then place date here.... =IF($F13<AC5,$F13,IF($F13Y5,$F13,"")) but this places the date in every cell that contains this formula, but I would like it to be empty, when it no longer falls within the dates of the header row to its right and left. Thanks you if you can enlighten me of my "between" mistake! Driftwood |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
formula to determine whether a date falls between two dates | Excel Discussion (Misc queries) | |||
finding if a date falls between two dates | Excel Discussion (Misc queries) | |||
finding if a date falls between two dates | Excel Discussion (Misc queries) | |||
return TRUE if a date falls between two dates | Excel Worksheet Functions | |||
How to find if a date falls between 2 dates | Excel Worksheet Functions |