Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Birthday Formula
I have a long spreadsheet with birth dates (ie. 01/01/2001) on column A. Is
there a formula that can calculate into number of years to the present date. For example, Col A= 04/7/04, Col B =1 year. I'm not sure how to aproach this, thanks inadvance. Using office 2000. Joe |
#3
|
|||
|
|||
You could use the function YearFrac and Now, like this:
=YEARFRAC(A2,NOW()) This will give you the years and/or fractions between today's date and the date reference, in this case the date in cell A1. You can use the Round function too to show the result as whole years: =ROUND(YEARFRAC(A1,NOW()),0) but experiment to get the rounding to do what you want it to: you might want to use Roundup or Rounddown instead. "Joe" wrote: I have a long spreadsheet with birth dates (ie. 01/01/2001) on column A. Is there a formula that can calculate into number of years to the present date. For example, Col A= 04/7/04, Col B =1 year. I'm not sure how to aproach this, thanks inadvance. Using office 2000. Joe |
#4
|
|||
|
|||
Forgot to say - you'll need the Analysis Toolpak added for the YearFrac
function to work. Go to Tools, Addins and check the Analysis Toolpak checkbox. "Joe" wrote: I have a long spreadsheet with birth dates (ie. 01/01/2001) on column A. Is there a formula that can calculate into number of years to the present date. For example, Col A= 04/7/04, Col B =1 year. I'm not sure how to aproach this, thanks inadvance. Using office 2000. Joe |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF & VLOOKUP FORMULA | Excel Worksheet Functions | |||
Problem with VBA returning the contents of a long formula. | Excel Discussion (Misc queries) | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
revert formula insertion to old method | Setting up and Configuration of Excel | |||
Help with macro formula and variable | Excel Worksheet Functions |