Questions

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

Tags:
+
0 Votes
Locked

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

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
  • +
    0 Votes
    Darryl~ Moderator

    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.

    +
    0 Votes
    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.

  • +
    0 Votes
    Darryl~ Moderator

    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.

    +
    0 Votes
    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.