Calendar Markers in Excel

I am using an excel template I found online and it works for most of the things I am attempting to do. However, the formulas are missing some additional conditions.

Currently:
When entering a date in column F, the "day of post" green dot will appear on the date.

Looking for:
I would also like for the formula to include the "teams post" a month in advanced, the "Website Page Post" two weeks in advanced, and the "Weekly News Update" a week in advanced. Can you help me update the formulas in the gantt-style calendar to show these additional color coded keys? Example of the color coding in line 20 (done manually).

I appreciate all help, and welcome easier ways to accomplish my goal of showing these important dates.

Welcome to the forum.

In AK20 copied across:

=IFERROR(IF(LEN(Milestones36[@[Days])=0,"",IF(AND(AK$12=$F20,$G20=1),Milestone_Marker,IF(AK$12=$F20-7,2,IF(AK$12=$F20-14,1,IF(AK$12=EDATE($F20,-1),0,""))))),"")

Thank you AliGW!

When I use that formula in my spreadsheet I get an 'inconsistent formula' error and the markers do not show up, but some numbers do

I tried the formula in AK20 as well with the same results as the image below.

2023-07-28_10-32-45.png

Attach the workbook where it isn't working.

The screenshot isn't showing the formula so I can't even troubleshoot!

Yes, you will get an inconsistent formula warning (which you can switch off) because the formula is for the row where you want the advance notice icons.

Working version attached.

PS It would appear that you have removed the conditional formatting that had been applied - I need to see the workbook where it isn't working. You've changed something compared to the workbook you gave us to use.

Please replace Milestones36[@[Days] with Milestones36[@Days] (so remove the second "[")

You've drag copied the formula instead of copying it and pasting (paste special - formula). That's why it's not working. When you drag copy, the table column references change as you drag - you don't want that. You've also messed up the formatting of the row. Your workbook keeps crashing, so I suggest you go back and start again with the version I attached to post #4.