Due date calculation formula

[Sherijoe]

I need an "if" "then" formula for dates. I am trying to have it automatically figure due dates. Anything received from the 1st to the 15th is due the end of the same month. anything received the 16th - the 31st is due 30 days from date of receipt. Can anyone create a formula for this, please?

 

[Joe4]

Welcome to the Board!

For a date in cell A2, try this formula:

=IF(DAY(A2)>15,A2+30,EOMONTH(A2,0))

And here is the proof-of-concept:

 

[Sherijoe]

Thank you! That works perfectly.

 

[Joe4]

You are welcome!
Glad I was able to help.