Hi,
Grateful if someone can assist. If type in column C is = "M", I need a Star along the horizontal monthly columns based on the End date in column E.
thanks in advance for assistance and help!
Grateful if someone can assist. If type in column C is = "M", I need a Star along the horizontal monthly columns based on the End date in column E.
thanks in advance for assistance and help!
Tasks/Milestones | Type | Start Date | End Date | Q3 2021 | Q4 2021 | |||
30-Sep-2021 | 30-Oct-2021 | 30-Nov-2021 | 30-Dec-2021 | |||||
grapes | M | 1-May-2021 | 1-Sep-2021 | blue star goes here | ||||
apples | M | 27-Sep-2021 | 29-Oct-2021 |
| ||||
oranges | M | 27-Sep-2021 | 3-Dec-2021 | blue star goes here |