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 so much for your help!
I also got it to work by entering =IF(H$3=($D6-WEEKDAY($D6,2)+5),"u",""). I am still learning a lot about this type of formula and am having trouble making sense of what the 2 (or 15 in your formula) does, as well as the "+" numbers.
I also got it to work by entering =IF(H$3=($D6-WEEKDAY($D6,2)+5),"u",""). I am still learning a lot about this type of formula and am having trouble making sense of what the 2 (or 15 in your formula) does, as well as the "+" numbers.
See info about the WEEKDAY function