| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date range - recognise end of each month
I have an Excel Gantt chart. I would like to add a line down the rows to
coincide with each month end, so that each month range has verticla boundaries. The date range is along row 27. I use conditional formating to recognise weekends so I suspect I can also use conditional formatting to recognise month ends. Can anyone help? Thanks, Roger |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Recognise text as date | Excel Worksheet Functions | |||
| 1st Monday of a month in date range?? | Excel Worksheet Functions | |||
| Locate month n year from range of date | New Users to Excel | |||
| How do I break a date range by month? | Excel Discussion (Misc queries) | |||
| How do you sort a date range by month? | Excel Discussion (Misc queries) | |||
Threaded Mode
