Hi Excel experts,



In the attached file Query108.xls, I need to count the total year lapse based on a specific date, i.e. Birthday. Please show-advise how to set formula in:

1) Sheet1, Cell C6 to C8 to compute for total years lapsed based on current computer date, so that if i reset the PC date the computation also resets;

2) Sheet2, Cell B5 to B7 to copy from sheet1 to sheet2 with data as-is;

3) Sheet2, Cell F5 to F7 to copy from sheet1 to sheet2 but with the total-years data now sorted from H-L.

Thanks in advance.

Kim

Attached Files

Query108-How to count year lapse based on specific date.xls (23.0 KB, 11 views)

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.