Software

Question

Locked

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

By ·
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

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

Collapse -

There's a couple way to do this

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

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

Collapse -

by 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

• 3

eldan369 ·

• 11

ACTIVATING RESITRATION AFTER SELLER STOPS BUSINESS

dee1620814688 ·

• 3

zamsam676 ·

• 7

marti830 ·

• 1

pdyason ·