|
-
Mar 28th, 2007, 03:47 AM
#1
Thread Starter
Lively Member
[RESOLVED] ages
in excel i am using this formula to work out someones age,
=INT($B$2-C11)/365.25
where $b$2 is todays date and c11 is the DOB
but it rounds it up so if they are 15 and a half it puts that they are sixteen, how can i force excel to round down.
thanks
joe
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|