ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   subtract year and divide (https://www.excelbanter.com/excel-worksheet-functions/51980-subtract-year-divide.html)

crystal

subtract year and divide
 
how do i subtract years and then divide everytime i do i am not getting the
same answer in my workbook.

Zack Barresse

subtract year and divide
 
Hi,

Can you post what your values, formulas, results and desired results are?

--
Regards,
Zack Barresse, aka firefytr, (GT = TFS FF Zack)
To email, remove the NO SPAM. Please keep correspondence to the board, as
to benefit others.


"crystal" wrote in message
...
how do i subtract years and then divide everytime i do i am not getting
the
same answer in my workbook.




Bob Phillips

subtract year and divide
 
Bit light on detail here. Do you mean subtract years in two cells, if so,
what happens when it is not exact years? And divide what by what?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"crystal" wrote in message
...
how do i subtract years and then divide everytime i do i am not getting

the
same answer in my workbook.




Vacation's Over

subtract year and divide
 
HELP ADD DATES


"Bob Phillips" wrote:

Bit light on detail here. Do you mean subtract years in two cells, if so,
what happens when it is not exact years? And divide what by what?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"crystal" wrote in message
...
how do i subtract years and then divide everytime i do i am not getting

the
same answer in my workbook.





Zack Barresse

subtract year and divide
 
I'm confused here. What does "HELP ADD DATES" mean?

--
Regards,
Zack Barresse, aka firefytr, (GT = TFS FF Zack)
To email, remove the NO SPAM. Please keep correspondence to the board, as
to benefit others.



"Vacation's Over" wrote in message
...
HELP ADD DATES


"Bob Phillips" wrote:

Bit light on detail here. Do you mean subtract years in two cells, if so,
what happens when it is not exact years? And divide what by what?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"crystal" wrote in message
...
how do i subtract years and then divide everytime i do i am not getting

the
same answer in my workbook.







Chip Pearson

subtract year and divide
 
It means look up 'add dates' in the help file.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Zack Barresse" wrote in message
...
I'm confused here. What does "HELP ADD DATES" mean?

--
Regards,
Zack Barresse, aka firefytr, (GT = TFS FF Zack)
To email, remove the NO SPAM. Please keep correspondence to
the board, as
to benefit others.



"Vacation's Over"
wrote in message
...
HELP ADD DATES


"Bob Phillips" wrote:

Bit light on detail here. Do you mean subtract years in two
cells, if so,
what happens when it is not exact years? And divide what by
what?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"crystal" wrote in
message
...
how do i subtract years and then divide everytime i do i am
not getting
the
same answer in my workbook.








Bob Phillips

subtract year and divide
 
I did, but it didn't help me see the question in any clearer light :-))


Bob


"Chip Pearson" wrote in message
...
It means look up 'add dates' in the help file.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Zack Barresse" wrote in message
...
I'm confused here. What does "HELP ADD DATES" mean?

--
Regards,
Zack Barresse, aka firefytr, (GT = TFS FF Zack)
To email, remove the NO SPAM. Please keep correspondence to
the board, as
to benefit others.



"Vacation's Over"
wrote in message
...
HELP ADD DATES


"Bob Phillips" wrote:

Bit light on detail here. Do you mean subtract years in two
cells, if so,
what happens when it is not exact years? And divide what by
what?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"crystal" wrote in
message
...
how do i subtract years and then divide everytime i do i am
not getting
the
same answer in my workbook.










Anne Troy

subtract year and divide
 
LOL!!
************
Anne Troy
www.OfficeArticles.com

"Bob Phillips" wrote in message
...
I did, but it didn't help me see the question in any clearer light :-))


Bob


"Chip Pearson" wrote in message
...
It means look up 'add dates' in the help file.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Zack Barresse" wrote in message
...
I'm confused here. What does "HELP ADD DATES" mean?

--
Regards,
Zack Barresse, aka firefytr, (GT = TFS FF Zack)
To email, remove the NO SPAM. Please keep correspondence to
the board, as
to benefit others.



"Vacation's Over"
wrote in message
...
HELP ADD DATES


"Bob Phillips" wrote:

Bit light on detail here. Do you mean subtract years in two
cells, if so,
what happens when it is not exact years? And divide what by
what?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"crystal" wrote in
message
...
how do i subtract years and then divide everytime i do i am
not getting
the
same answer in my workbook.













All times are GMT +1. The time now is 03:10 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com