Converting "1 Years 10 Months 3 Days" From Today into an Actual Date?

[Marengah]

Hello All!

I am in desperate need of a solution to this problem. While the logic is simple enough, my research on executing hasn't been as fruitful. Any input would be greatly appreciated.

For this example, I have " 1 years 10 months 3 days " in cell B2. Today's date next to it set as 02/06/2025 (Feb 6th 2025). My expected output is the date 04/03/2023 or April 4th 2023 as that is the date exactly 1 years 10 months 3 days from today.

Hopefully I'm making sense. Any help is greatly appreciated!

Thank you in advance!

 

[Peter_SSs]

If you are still using Excel 2019 try this. Format the result column with whatever date format you want.

25 02 07.xlsm
	B	C
1
2	1 years 10 months 3 days	04-April-2023
3	4 years 1 months 20 days	18-December-2020
4	2 years 0 months 2 days	05-February-2023
Future date

Cell Formulas
Range	Formula
C2:C4	C2	=EDATE(TODAY(),-LEFT(B2,FIND(" ",B2))*12-MID(B2,SEARCH("months",B2)-3,2))-MID(B2,SEARCH("days",B2)-3,2)

 

[Holger]

here is another formula that could work

Test - Update1.xlsx
	J	K	L	M	N	O
32	1 years 10 months 3 days			2/7/25		4/4/23
Test

Cell Formulas
Range	Formula
M32	M32	=TODAY()
O32	O32	=DATE(YEAR(M32)-VALUE(LEFT(J32,SEARCH(" years",J32))),MONTH(M32)-VALUE(RIGHT(LEFT(J32,SEARCH(" months",J32)),3)), DAY(M32)-VALUE(RIGHT(LEFT(J32,SEARCH(" days",J32)),3)))

 

[Peter_SSs]

@Marengah
Noting that different months have different numbers of days in them, can you please confirm what result you would expect if TODAY was 31 March 2025 and the text was "0 years 1 months 0 days"?

 

[Marengah]

If you are still using Excel 2019 try this. Format the result column with whatever date format you want.

25 02 07.xlsm
	B	C
1
2	1 years 10 months 3 days	04-April-2023
3	4 years 1 months 20 days	18-December-2020
4	2 years 0 months 2 days	05-February-2023
Future date

Cell Formulas
Range	Formula
C2:C4	C2	=EDATE(TODAY(),-LEFT(B2,FIND(" ",B2))*12-MID(B2,SEARCH("months",B2)-3,2))-MID(B2,SEARCH("days",B2)-3,2)

Thank you so much, you are the MVP!

 

[Peter_SSs]

Thank you so much

You're welcome. Thanks for the follow-up.