Microsoft Excel help- need help knowing how this formula works: - HotUKDeals
Get the HotUKDeals app free at Google Play

#### Search Error

An error occurred when searching, please try again!

# Microsoft Excel help- need help knowing how this formula works:

£0.00 @
Heres the formula : =DATEDIF(D2,NOW(),"y") The formula works fine but i wana know how excel works out the age from the date of birth. I know a little like it divides it by 365 days i think well som… Read More
7y, 7m agoPosted 7 years, 7 months ago
Heres the formula : =DATEDIF(D2,NOW(),"y")

The formula works fine but i wana know how excel works out the age from the date of birth. I know a little like it divides it by 365 days i think well something along those lines.
7y, 7m agoPosted 7 years, 7 months ago
Options

(3)
#1
well from your date of birth surely it would just do a super quick calculation of how many bdays youv had?
#2
Carley
DATEDIF is the formula
D2 is the cell so i guess you have a DOB in this cell
NOW() is telling the system today's date so it can work out the difference between the date in cell D2 and today's date
Y is the format to display the result.

thanks
#3
scott1295
well from your date of birth surely it would just do a super quick calculation of how many bdays youv had?

its not as simple as that lol