BSUSD Tech Blog, Kevin Pedersen
blog
Search
Tags:
5th grade
excel
History
Updated May 13, 2010 3:00 PM by
kevinp
…
Date Formulas
We used the formula =int((today()-b2)/365)
to create a birthday list.
We later edited the formula to
=INT((TODAY()-$B2)/365)
The dollar sign was needed to lock in the reference to the birthday cell.
←
↑
→