|
formula to automatically calculate customer age
I don't seem to understand how to create a formula that will automatically
enter a client's age in years using "TODAY" and their date of birth. I want it to automatically apply to all entries in the database. In a previous version (2003?) the formula was =(NOW()-dob)/365. TODAY has replaced NOW but the formula =(TODAY()-dob) doesn't work. Can anyone help? |
formula to automatically calculate customer age
With DOB in A1,
In B1: =DATEDIF(A1,TODAY(),"y") Format B1 as general -- Max Singapore http://savefile.com/projects/236895 Downloads:19,500 Files:362 Subscribers:62 xdemechanik --- "bubbles galore" wrote: I don't seem to understand how to create a formula that will automatically enter a client's age in years using "TODAY" and their date of birth. I want it to automatically apply to all entries in the database. In a previous version (2003?) the formula was =(NOW()-dob)/365. TODAY has replaced NOW but the formula =(TODAY()-dob) doesn't work. Can anyone help? |
| All times are GMT +1. The time now is 12:29 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com