Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Grouping and Listing Projected Projects By Inclusive Dates
I have a projects worksheet in which I have a Current Date Cell ("F1")
and four columns ("A, B, C, D") which have dates. "A1" = Estimated Start Date "B1" = Estimated Finish Date "C1" = Actual Start Date "D1" = Actual Finish Date Each project has the same set of "A-D" dates. I want to be able to do a 3 month projected projects chart (or list) which will show the current date + columns "A1 thru D1" dates. For example: Current date = 7/24/03 Projected Project Dates: Current Month Next Month Two Months from Now A1-D1 A1-D1 A1-D1 Is there a macro that would give me this information. Or, code that will allow me to do this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Projected Dates.... | Excel Discussion (Misc queries) | |||
Listing Projects based on Manager Name | Excel Discussion (Misc queries) | |||
Calculating inclusive dates | Excel Discussion (Misc queries) | |||
Calculating Projected Dates | Excel Worksheet Functions | |||
Locating a range of dates and listing somewhere else? | Excel Discussion (Misc queries) |