need a formula Closed

Question

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.

Mazzaropi · Answer

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

Mazzaropi · Answer

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.

Need a formula

2 responses

Similar discussions

Subscribe To Our Newsletter!