Date Increment

[gk759]

Hi,

I am trying calculate due date of invoices based on the invoice date.
for e.g if the date is 1/13/05. I was wondering if there is formula that will automatically calculate the due date 30 and 45 days from the date of the invoice.

Any input in this respect I will appreciate,

Thanks in advance,

Gary

 

[KLewisBPM]

Hi

If you have a date in A1 and a date in B1. in C1 you can put A1 - B1 and format C1 as a number field.

i.e.

Row ColumnA Column B Column C
1 01/01/05 13/01/05 =A1-B1 Result = -12







Kind Regards

Kelley Lewis

 

[gizmo1973]

In one cell =(a1+30)
in another cell =(a1+45)
Assuming your date is in a1 if not choose that cell.
Format as date throughout

Regards, Phil.

M.U.F.C. Show your true support here:

http://www.shareholdersunited.org/join.php

"Shares not Shirts