Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Good afternoon all,
I have a starting date column, the first value is in F3 (2/13/2006). I have an ending date column, the first value is in F4 (4/21/2006). In H2:N77 I have a 2006 calendar. H2 is merged through M2, and contains "January". N2 contains 1/1/2006. H3:N7 display the January calendar with 4 blank cells (K7 - N7). This repeats respectively for the remaining months. Goal: When a stating date is selected, highlight the event range on the calendar. Example: If F3 is selected, Highlight 2/13/2006 (I11) through 4/21/2006 (M24). If anyone knows of an article or reference where I can learn more information to solve this, it would be greatly appreciated! Thank you much, and Happy early Thanksgiving! Renee |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
PivotTables - Group Dates, excluding dates | Excel Discussion (Misc queries) | |||
Calculating number of days between two dates that fall between two other dates | Excel Discussion (Misc queries) | |||
Simple question: Difference between two dates? | Excel Discussion (Misc queries) | |||
Question on sorting dates | Excel Discussion (Misc queries) | |||
Another question regarding Dates.. | Excel Discussion (Misc queries) |