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

 

[Salamullah]

<TABLE style="WIDTH: 205pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=273 border=0 x:str><COLGROUP><COL style="WIDTH: 66pt; mso-width-source: userset; mso-width-alt: 3218" span=2 width=88><COL style="WIDTH: 73pt; mso-width-source: userset; mso-width-alt: 3547" width=97><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD class=xl23 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 66pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" width=88 height=17>Receipt Date</TD><TD class=xl23 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 66pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=88>Credit Terms</TD><TD class=xl23 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 73pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=97>Payment Date</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>18/07/2011</TD><TD class=xl22 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" align=right x:num>60</TD><TD class=xl22 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"> </TD></TR></TBODY></TABLE>

 

[anandvarma]

try this

Excel Workbook
	A	B	C
1	18/07/2011	60	16/09/2011
Sheet1

 

[Salamullah]

sorry its giving following error

<TABLE style="WIDTH: 48pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=64 border=0 x:str><COLGROUP><COL style="WIDTH: 48pt" width=64><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 48pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=middle width=64 height=17 x:err="#VALUE!">#VALUE!</TD></TR></TBODY></TABLE>

 

[Salamullah]

Please help

 

[R Pelle]

Make sure the formula refers to the date 18/07/2011 and the period 60.
If you are using the above example of =A1 + B1 then your date and period should be in A1 and B1.

If your headings are in row 1 and your data starts in row 2 then amend formula to =A2 + B2

In other words if A1 contains 'Receipt' and B1 contains 'credit' then formula in C2 =A1+B1 will return #VALUE! but C2 = A2+B2 will return 13/03/2011.

 

[Salamullah]

Yes the formula is refers to the date 18/07/2011 A1 and the period 60 B1 and result am expecting in C1 with calculation =A1+B1, but giving same error #VALUE!

 

[R Pelle]

I'm sorry to say but I'm running out of ideas here. You may want to look at the formatting styles of your cells in columns A,B,C.
THe other thing you could try is create a new workbook and add just one sample to see if that solves the #value issue.

Rob.

 

[scottylad2]

Try =(A1+B1)+o what does that produce? I suspect your date entry is text

 

[Salamullah]

I am sorry, I am so dump, I tried all the techniques but still getting the same error #value