I am working on projects that come in every 4 and a half month. I want to make a calender so I can see when the deadline is for each project.
I have a formula that adds up 4 months and 14 days. (4,5 months)
The formula works well but it works too well. I need a formula that adds up 4 months and 14 days so that each row starts with a date of either the first of a month or the 15th of a month.
I tried to make an extra row from here with a -IF DAY value greater/smaller as 15 but I can't seem to get it working at all. My excel expertise is limited, I'm afraid...