Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

excel

ResolvedVersion 2003

Edward has attended:
Excel Introduction course

Excel

TIME and HOURS in Excel

RE: Excel

Hi Edward, thanks for your query. The following link has a good breakdown of time-related problems in Excel and their solutions. Have a lookand see if it helps with the problem we discussed.

http://www.cpearson.com/excel/datearith.htm

Let me know how you get on and all the best,

Anthony

Mon 28 Jun 2010: Automatically marked as resolved.

Excel tip:

DATEDIF function

The DATEDIF function is a worksheet function that computes the difference between two dates. This function is documented only in the help files for Excel 2000. It isn't documented in Excel 2002.
the formula function is:
=DATEDIF(Your age,Today(),"Y")
Y stands for year

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.17 secs.