Excel Project Gantt Chart: Adding Milestone Diamond

Super helpful, thank you!

Do you know why the complete and 'on hold' formulae aren't showing up?

maryphd 

Select K6:BJ34. K6 should be the active cell in the selection.

Enter the following formula and confirm it by pressing Ctrl+Enter to populate the entire selection:

=IF($F6-DAY($F6)+1=K$4, "u", "")

 

Yes, thank you! I assume that's why the other formulas I've added as 'new rules' aren't working since I'm doing months rather than days.

https://bangoroffice365-my.sharepoint.com/:x:/g/personal/mrw19rcc_bangor_ac_uk/EYngKvIqOgBOgdEf3Cxd2FsBDmMYiW75azafZl2ARYlFJQ?e=NeUWyc

maryphd 

Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?

I just saw that you PMed me. Stay tuned.

Could I also get some help? I'm trying to do milestones for months rather than days.

lisapeek 

See info about the WEEKDAY function 

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.

lisapeek 

For weeks beginning on Friday:

Select H6:BT52. H6 should be the active cell in the selection.

Enter the formula

=IF(H$3=($D6-WEEKDAY($D6,15)+1),"u","")

and confirm it by pressing Ctrl+Enter.

It doesn't really matter, I just made it on a Friday so set it up like that. I just noticed when I changed my dates to Mondays it works. How frustrating!

For learning purposes, what is the correct formula for weeks beginning on Fridays?

lisapeek 

Thanks! The dates in H3 to BT3 are Fridays. Is that your intention?