Question about Computers & Internet

1 Answer

Excel formula I have a list of bithdates and need to change them to age can someone help me with a formula that will convert these dates Than You

Posted by on

  • gfer Mar 19, 2008

    Thank you for your idea, when I entered your formula my spreadsheet didn't recognise the (Today error message read the function is not a valid works function, can you help me with this

    Thank You again

×

1 Answer

  • Level 1:

    An expert who has achieved level 1.

  • Contributor
  • 2 Answers

Try this

=(TODAY()-YOUR_CELL_HERE)/365

Posted on Mar 19, 2008

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

How to move the result of a formula up or down one cell


go google and type in --manual for excel version (what ever it is ) and down load the pdf file
go to a book shop and buy a Excel for dummies book
or e-bay and excel for dummies or other excel explained books
explaining it as a reply will be as confusing as the reply would be pages long

Oct 13, 2015 | Microsoft Excel for PC

3 Answers

Pls help to write an excel formula to display date, thanks! Cell A1 input a date - 1 Sep 10, Cell B1 write a formula to calculate & display the date which = (A1 + 14 days but if the result is a...


This is too complicated for a help site like this, you are going to want to consult an excel forum, or some excel professional in your area. This is far beyond the scope of what you can expect for $15, which I'm sure you now realize after 10 days of trying.

Thanks
Tim

Sep 26, 2010 | Microsoft Excel for PC

1 Answer

I want my clients' age to automatically calculate using Date of Birth. In previous versions of Works Database it was a simple formula, but I can't seem to replicate it in Office Excel 2007.


Its the same only the interface is different. Use the same technique of the Mathematical algorithm keeping in mind the way the date, time are displayed in their format. Also switch to 24 Hr mode....sodeep

Mar 20, 2009 | Microsoft Office Excel 2007

2 Answers

Excel formulas


Here is your formula

=IF(A1 < 25,10/100 * B1, 5/100 * B1)

A1 is the Age of client
B1 is the car value


Oct 27, 2008 | Microsoft Excel for PC

3 Answers

Need excel solution


Hello ycool11, If your asking what i think you are the formula would be
=(a2-a1)*24
That assumes a2 is that last date entered and a1 is the initial starting date. if you would like a more intense formula let me know and i'm sure i can help.

Oct 22, 2008 | Microsoft Excel for PC

4 Answers

I need Excel's Furmula's


I found some excellent links to excel formulas for you:

This link lists excel formulas by category:

http://www.techonthenet.com/excel/formulas/

This link has some custom formulas for excel that you can download:

http://www.ozgrid.com/VBA/Functions.htm

Sep 20, 2008 | Microsoft Computers & Internet

2 Answers

Formula for calculating the days beween months


for example, cell A1 has date (01-01-2008) and cell A2 has current date (08-24-2008) and cell A3 shows total days, is that you want to know? if yes, apply formula as under...

cell A3......(properties set as General to show digits)................ =SUM(A2-A1)

Aug 25, 2008 | Microsoft Office Professional 2007:...

1 Answer

Excel Formula


Hello,

Do you mean convert to the current currency rate? like you have 1$ in the cell and you want it to show .70 £

or do you mean to change the symbol? from $ to £

let me know,

Chester

Jan 11, 2008 | Computers & Internet

2 Answers

EXCEL DATE RANGE FORMULA


Assuming birthdate is in cell B2:

=IF(B2<DATE(1997,5,1),"Too Young",IF(B2>DATE(1998,4,30),"Too Old","OK"))

Oct 26, 2007 | Oracle Database Enterprise Named User Plus

Not finding what you are looking for?
Computers & Internet Logo

Related Topics:

44 people viewed this question

Ask a Question

Usually answered in minutes!

Top Computers & Internet Experts

Les Dickinson
Les Dickinson

Level 3 Expert

18384 Answers

kakima

Level 3 Expert

102366 Answers

David Payne
David Payne

Level 3 Expert

14161 Answers

Are you a Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...