Formula to work out someone's age on a particular date

[kjglen87]

Hi all,

I have the DOB off my students and need to work out their age on a specific date.

So for example DOB: 01/01/2006 and I want to know how old they would be on 12/10/2018?

Can this be done? As I have many students all different ages?

Thanks

 

[mrshl9898]

=(Date - DOB) / 365.25

 

[AhoyNC]

Another option:

Excel Workbook
	A	B	C
1	DOB	To Date	Age
2	1/1/2006	12/10/2018	12
3	5/6/2008	12/12/2018	10
4	6/7/2001	5/6/2019	17
Sheet