Calculate the expected date of payment based on the document date plus the net terms

[kumar0318]

Hello- I have a document date which is in the format yyyymmdd (20240909) plus the payment terms for this document 90.. how do i show the expected payment date in a new column?
Thank you in advance for your help!

 

[Cubist]

Are they real dates or are they strings? Test with =ISNUMBER(cell)

 

[kumar0318]

This does not work. I have the real dates in one coloumn and then payment terms ( 60) in the other column. I need to insert a new column and show the expected date of payment based on these two columns.

For example: If my document date 12/31/2024 and payment terms is 60 then the expected value should be 02/28/2025.

 

[Cubist]

This does not work.

I was asking you to check whether your cells are real dates or strings. The solution depends the type.

I have the real dates

You can simply add 60 to the date.

Book4
	A	B	C
1	12/31/24	60	3/1/25
Sheet8

Cell Formulas
Range	Formula
C1	C1	=A1+B1

 

[Holger]

your document date format in #1 and #3 are different. Assuming your post #3 is correct and NOT recognised as a date, this might be worth testing:

Book1
	A	B	C	D
1	12/31/2024	60		3/1/25
Sheet1

Cell Formulas
Range	Formula
D1	D1	=DATE(RIGHT(A1,4),LEFT(A1,2),MID(A1,4,2))+B1

 

[kumar0318]

Thank you!

 

[Cubist]

your document date format in #1 and #3 are different. Assuming your post #3 is correct and NOT recognised as a date, this might be worth testing:

Book1
	A	B	C	D
1	12/31/2024	60		3/1/25
Sheet1

Cell Formulas
Range	Formula
D1	D1	=DATE(RIGHT(A1,4),LEFT(A1,2),MID(A1,4,2))+B1

Excel will pick up "12/31/24" as date, even if they're strings, when performing calculation. The string extraction isn't necessary.