Google Sheets formula help

I’m trying to do something in Google Sheets, and have been unable to get it to work.

If anyone can help/show off their spreadsheet skills, I would be very grateful.

I’ve made a demo spreadsheet to show you what I mean without revealing my data:

I want the big merged cell in D and E columns to show the date at which the expected progress column first gets to 100.

In my real spreadsheet I have other data and factors which controls the progress percentage, and it is often changing.

Getting the expected completion date in that big cell should be easy, but I have been unable to get it working. Many thanks to those that can solve this issue :smiley:

I think chatGPT might have solved it. Let me try and implement the solution


It worked

1 Like

Great stuff from ChatGPT


Who is this ChatGPT guy, they seem to know everything?

1 Like
1 Like