Fresh Excel Tips

Quick and Easy Excel Tips and Tutorials

How to Use the YEARFRAC function to calculate employees ages
Addicted To Cialis Medrol Packs Buying Viagra Over The Internet Bio Brite Sun Alarm Can Plavix Substitute For Coumadin Viagra And Affiliate Breast Augmentation Discussion Boards Natural Herb For Lasix Plavix And Inr Breast Enhancement Capsules Ultra Curves Estrogen Coral Calcium Supreme 240 Zelnorm Affects Birth Control Patti Labelle Clas Of The Choirs Benefit Of Coral Calcium Hgh Effects On Teens Buy Hgh Buy Hgh Buy Hgh Anoretic Cardura Medication Leukeran Pet Medication Levitra For Females Out Of Court Settlement For Viagra Prednisone Prescribing Lamictal Bipolar 1 Aleve Pregnancy Coumadin Anticoagulation Drug Interaction Cipro Zoloft And Sudafed Plavix And Aspirin Interactions Use Zovirax For Effective Herpes Treatment Medrol Dose Pack And Crohns Synthroid Hot Flashes Geodon Im Cialis Manufacturer Jewish Purim Cookies Squill And Lipitor Synthroid Destroys Thyroid Advil Or Motrin Atarax Prescribing Information Flonase For Kidney Stones Lotrisone Cr 30 Mg Cost Of Viagra In The Philippines Can I Take Prozac At Night Zoloft Cleft Palatte Benefit Of Coral Calcium 0a North Beach Pizza Soma San Francisco Viagra Over Counter Herb Valproic Depakote Hypothalmus Hoodia Tlc Lasix Veterinary Dose Of Tramadol Neurontin Use

To calculate the difference between two dates, use the YEARFRAC function from the Analysis ToolPak add-in. This function calculates the fraction of the year represented by the number of whole days between start_date and end_date. The syntax is:

YEARFRAC(start_date, end_date, basis)
start_date: The start date.
end_date: The end date.
basis: Count basis to use. 0 or omitted = U.S. (NASD) 30/360, 1 = actual/actual, 2 = actual/360, 3 = actual/365, or 4 = European 30/360.

To calculate the age of employees based on the current date:

  1. In column A list the names of employees.
  2. In column B enter their birthdays.
  3. Select cells C2:C10 and type the formula TODAY().
  4. Press Ctrl+Enter.
  5. Select cells D2:D10 and type the following formula: =YEARFRAC(B2,C2,0).
  6. Press Ctrl+Enter.

How to Use the YEARFRAC function to calculate employees ages

How to Use the YEARFRAC function to calculate employees ages
  1. How to Use the DATEDIF function to calculate the ages of employees
  2. How to Calculate the number of employees needed for a project
  3. How to Use the QUARTILE function to calculate the quartiles
  4. How to Use the SYD function to calculate depreciation in Excel
  5. How to use the WORKDAY function to calculate workdays in Excel

Article Information

Category
Formula and Function Examples

Tags
, , ,

Trackback URI

Comments RSS


Leave a Reply

← How to Use the PRODUCT function to multiply values in Excel
Using the SUM function to Sum a Range of Values in Excel →