![]() |
|
#1
|
|||
|
|||
![]()
to calculate the difference between two dates, in years, use:
=DATEDIF(B6;NOW();"y") Notice that now() is the computer date, and in B6 is the date value entered. "y" can be replaced with "m", or "d", or "md", depending on your needs. Have you ever tried to study an well made excel function dictionary , with most of the functions explained? I recomend you http://www.xlfdic.com/ For sorting data, you better organize data in a named table, you can do lots of things with your data; a formula cannot sort data in a table. |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
fithawk | Word | 11 | 12-21-2016 02:50 AM |
Creative Ways for a year-to-year comparison??? | ridonkulous5 | Excel | 1 | 03-23-2011 04:49 PM |
![]() |
mcarter9000 | Word VBA | 5 | 12-23-2010 12:39 PM |
![]() |
janak | Excel | 6 | 12-12-2010 10:08 PM |
Rounded number | breskva | Word | 0 | 06-13-2010 10:50 PM |