Need a formula

Closed
doutol1 Posts 3 Registration date Tuesday August 23, 2016 Status Member Last seen August 23, 2016 - Aug 23, 2016 at 04:46 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Aug 24, 2016 at 09:06 AM
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 responses

Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Aug 23, 2016 at 11:52 AM
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
doutol1 Posts 3 Registration date Tuesday August 23, 2016 Status Member Last seen August 23, 2016
Aug 23, 2016 at 01:20 PM
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?
doutol1 Posts 3 Registration date Tuesday August 23, 2016 Status Member Last seen August 23, 2016
Aug 23, 2016 at 01:32 PM
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)
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Aug 24, 2016 at 09:06 AM
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.