Need a formula

[Closed]
Report
Posts
3
Registration date
Tuesday August 23, 2016
Status
Member
Last seen
August 23, 2016
-
Posts
1942
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
September 2, 2021
-
on 1/1/16 (a1) , John (b1) told me he'd pay me $1 in 30 days.
i want a formula that will automatically add 30 days from (a1) in date form in another cell based on the SPECIFIC text entered in (b1)

column "a" has a preset date
column "b" has SPECIFIC text

If column "b" = specific text, i need column c to equal a certain number of days starting from the date listed in column "a". the range could be anywhere from 1-31 from the date listed in column "a".

please help, I've been racking my brain trying to figure this out. thanks.

2 replies

Posts
1942
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
September 2, 2021
145
doutol1, Good morning.

Suppose:
A1 --> 1/1/16
A2 --> 50
B1 --> John told me he'd pay me

Try to use:

C1 --> ="On " & TEXT(A1,"M/D/YY ") & B1 & TEXT(A2," $ 00 ") & "in " & TEXT(A1+30,"M/D/YY ")

RESULT:

C1 -->
On 1/1/16 John told me he'd pay me $ 50 in 1/31/16

Is this what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Posts
3
Registration date
Tuesday August 23, 2016
Status
Member
Last seen
August 23, 2016

thank you! this is very close. I've played with this and really, the only thing I need is the date in "c1". Is that possible using the same to formula?
Posts
3
Registration date
Tuesday August 23, 2016
Status
Member
Last seen
August 23, 2016

sorry. let me be more clear. this works. (adding 30 days in date from from another cell) but i want to make sure that my formula will recognize the fact that (john= +30 days) and know to add 30 when his name is entered. not only in "c1", but moving forward. (incase John owes me money in the future)
Posts
1942
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
September 2, 2021
145
doutol1, Good morning.

"...the only thing I need is the date in "c1". Is that possible using the same to formula?..."
Try it:
C1 --> =A1 + 30
Format C1 to DATE

Sorry. I've read your second message a few times and I could not understand your need.
Remember, you master your information and your work and we are just trying to help you with Excel.

Please, save your spreadsheet on a free website, www.speedyshare.com, and place the download link here.
Show exactly what is the expected result and how it should work.

So it will be easier to help you effectively.