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.**

```
=DATE(YEAR(A1)+0,MONTH(A1)+4,DAY(A1)+15)
```

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...