If the number of days in cell A1 are greater than 15 days, add one month

[Excelody]

Hi.

I have a date in cell A1 (E.G 21/6/21) and I want to tell Excel:

"If the number of days in cell A1 are greater than 15 days, add one month"

So the date becomes "21/7/21".

I am basic user, not sure how to construct this. I am still learning excel grammar but I am lost with this one.

Ay help will be much appreciated.

 

[Phuoc]

Try this:

=EDATE(A1,IF(DAY(A1)>15,1,0))

 

[Excelody]

Thank you Phuoc, this worked like a charm. Thank you for your help today.
I wouldn't have been able to figure this out myself.