Dear Community,

I'm trying to work out a formula so that if an invoice issued in Jan with 30 days payment term, this amount is collectible in Feb, if 45 days payment term then collectible in Mar and so on. I tried if function, but it didn't seem to work. I might have formulated it incorrectly.

I attached the excel sheet and what expect return is. Hope for some help please.

Thanks,
Haha

Attached Files

AR collection.xlsx (9.5 KB, 5 views)