help me on range of Date

[keys2000]

Example

Disbursement Date Interest Due Date
02/01/2019 31/01/2019
15/01/2019 31/01/2019
16/01/2019 28/02/2019
17/01/2019 28/02/2019
28/01/2019 28/02/2019

01/01/2019 - 15/01/2019 - Interest Due should be end of the month
16/01/2019 - 31/01/2019 - Interest Due should be end of next month

how i want to formula my Interest Due Date?

[Sam Capricci]

you could try this...
=IF(AND(DAY(A2)>=1,DAY(A2)<=15),EOMONTH(A2,0),EOMONTH(A2,1))
you may need to substitute ; for , depending on your settings.

[keys2000]

TQ Sambo Kid

[Sam Capricci]

you are welcome! And thank you for the rep!