How to calculate 15th day based on a date field?

By McGnity ·
I need to calculate a date for every cell in a Excel sheet.
Something like if I get income this month I need to pay a bill on 15th day next month!
How to automatically calculate date 15th on next month if I get several incomes on days like 23/02/2012, 17/02/2012, etc. ?
I appreciate any coments.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

There's a couple way to do this

by Darryl~ Moderator In reply to How to calculate 15th day ...

Depending on how you want it calculated but suppose you put your invoice date in cell C8....


.....would display the 15th of the next month; if you want to go 2 monhs down the road then change the 0 to a 1.

Collapse -

Reponse To Answer

by McGnity In reply to There's a couple way to d ...

Just great Darry,
That was exactly what I was looking for.
Your tip solved my problem and helped me a lot.
Note: I just needed to use function in Portuguese (Brazilian).
For me sintax was "=FIMM??S(C8;0)15" and worked just fine.
Thank you once more.

Related Discussions

Related Forums