Question

Locked

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

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

3 total posts (Page 1 of 1)  
| 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....

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

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.

Back to Software Forum
3 total posts (Page 1 of 1)  

Software Forums