Credit terms

[Salamullah]

How can I calculate payment date if credit terms of a supplier is 60 days from the date of goods receipt.


Receipt Date Credit terms Payment Date
A1 B1 C1

18/07/2011 60 Formula ??

Thanks

 

[R Pelle]

If at all possible, try it on another PC that has Excel.

Rob

 

[Salamullah]

I have splitted date in 3 columns i.e. DD MM YY, in A1 18, B1 07, C1 11 and in D1 i have put 60 the credit terms.

Now what formula should I apply to see addition of 60 days in DD MM i.e. in column E1 11 and F1 09, 18/07/11 PLUS 60 = 11/09/11.

 

[Salamullah]

Thanks Rob,

Now it solves my problem

 

[R Pelle]

You're welcome, thx for the feedback.

 

[jevi]

http://www.cpearson.com/excel/datearith.htm

http://www.computing.net/answers/office/excel-forumula-to-add-30-days/5501.html



hope it helps..but i guess is something with the format still. But read the first article and i am sure you will find the solution .

 

[Salamullah]

Excellent article (The 1st one)

Thanks jevi