Question Locked

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

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi,
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.
Thanks

3 replies

by darryl~

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

=EOMONTH(C8,0)+15

.....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.

by mcgnity

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.

This discussion is closed to new replies.