Invoice due; Payment terms

[Guest]

Hi there,
I am working in Debtors statements. I get the invoice date from the
accounting package. I would like to create another column with the due date
by using a formula so I get something like this>>eg. Date inv 01.09.06.
Invoice due in 01.10.06. Any suggestion for this? Thanks in advance. Jose

 

[Guest]

This would the best example:
Date Credit terms Inv due
01.09.06 30 days 01.10.06 (this is what i want to achieve)

 

[Pete_UK]

Assuming your date field is column A and that it is in Excel date
format, and that Credit terms are 30 and not 30 days (which is text),
then try this in column C:

=A2+B2

Format this cell as a date.

Hope this helps.

Pete

 

[Guest]

Thanks, I needed to change the date to 01/09/2006 but it is working now
Any sugestion so if something is overdue at todays date it shoes in red
color and a message on the site.

eg 09/08/07 is overdue but 19/08/07 is not overdue yet

 

[David Biddulph]

If A2 and C2 are formatted as dates, and B2 is a number with custom format
#" days", then the formula for C2 is =A2+B2.

 

[David Biddulph]

Conditional formatting for the colour, and an IF statement for the message.
Use the function TODAY() as the reference for your comparison.