Excel help!

[alintatoc]

I am trying to calculate using formulas a due date in excel
Invoice date is: 01.12.2009 and the terms of payment is 30 days.

What is the formula to reach the due date?
I tried invoice date + 30 days but then I get a cell which has the message "value"

[TJohns]

Check that your InvoiceDate and formula cell are both formatted as Date and not as General (that date example with multiple dots may be getting treated as a string)

Maybe use CUSTOM format and enter dd.MM.yyyy as the mask

Trevor

[IKnowNothing]

I'm working in Office 2003 (with UK settings) but this should work in most versions

First format the cell with invoice date as a date (CTRL-1 on cell) enter date as 01/12/09
In the Due date you need to simply add 30 to the Invoice date again you may need to format the cell as a date

and it's as simple as that

Hope this helps

M

[alintatoc]

here is how it looks
I still did not manage

[guns1inger]

Make sure that the Invoice Date cells are formatted as Date.

In E6, type =A6+G3

By using G3 you can change the payment terms without having to change every due date cell.

[alintatoc]

Make sure that the Invoice Date cells are formatted as Date.

In E6, type =A6+G3

By using G3 you can change the payment terms without having to change every due date cell.

I doesn't seem to work if I try to format the invoice date cells

[alintatoc]

I managed something here but I have problem with one of the cells:


The result are market with pink, which indicates that it's bad...

[alintatoc]

Ok, I managed somehow
How do I calculate the no. of days overdue with E function?
How about the age of invoice?

[guns1inger]

Age of Invoice is =INT(TODAY() - A6)
Days overdue is =INT(TODAY() - E6)

[alintatoc]

Age of Invoice is =INT(TODAY() - A6)
Days overdue is =INT(TODAY() - E6)

Thanks a lot!
How do I calculate the no. of days overdue with IF function?

[guns1inger]

Example ? What are the conditions ?

[TJohns]

Sounds like you want Overdue to show only when it's ACTUALLY overdue.

Days OverDue =IF(INT(TODAY() - E6)>0,INT(TODAY() - E6), "")

Trevor