Hoping someone can help me out here with an interesting MS Excel problem as below:
I have three columns (sample data only below)
Start Date: (1/1/18)
End Date: (28/2/18)
Day of week: 5 (Friday)
Is there a way for me to calculate the precise date for every 'Friday' (in this example) within the date range?
I do not want the frequency or count of occurrences, I want the actual date associated with each Friday within the range
I would love to plot each occurrence on a Gantt style chart - your input would be greatly appreciated!
Hoping someone can help!