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
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Aug 24, 2016 at 09:06 AM
Related:
- Need a formula
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Date formula in excel dd/mm/yyyy - Guide
- Number to words in excel formula - Guide
- Excel grade formula - Guide
- Credit summation formula - Guide
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
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
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
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Aug 24, 2016 at 09:06 AM
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.
"...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.
Aug 23, 2016 at 01:20 PM
Aug 23, 2016 at 01:32 PM