Forum Discussion
Solved
Excel Project Gantt Chart: Adding Milestone Diamond
Hello, I am trying to put a diamond shape in my excel project from: https://www.youtube.com/watch?v=tuQpGzL_14g&t=2s On 9:21. Can someone please help me why this is not working? ↓
I have received the workbook. The problem was not in the character, but in the formula.
The formula in J6 should be
=IF(J$4=$E6-WEEKDAY($E6,13)+7,"u","")
with the font set to Wingdings. Fill to the right and down. See the attached version.
Thanks. The dates in row 3 are Sundays, so you have to adjust the formula for that. In I5:
=IF(I$3=$E5-WEEKDAY($E5,2),"u","")
And the font of I5:CI46 should be set to Wingdings.
See the attached version.
Thank you so so much Hans i have been at this all night. So thank u