TEXT function heads up!

I was going through a file that used TEXT formula to calculate the difference between dates. It was a file from human resource department file which calculated the age of the employees using TEXT formula. Initially it looked very easy and useful. I have been using DATEDIF function all this years and in front of TEXT it looked so cumbersome. Then I compared the results from the two functions. To my surprise the results were different.

date1

The results from TEXT formula were higher by one month or more. It appears that TEXT formula while it take care of years but for months it complete the full cycle of 12 months ignoring dates. Although on lighter side someone who is 30 year old would not mind a month or two added to his age but an infant like my daughter certainly would.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s