Re: How do I convert 'YYYYMMDD to an age in Excel?

[Sandy Mann]

With your downloaded DOB in G1 try:

=DATEDIF(DATE(--LEFT(G1,4),MID(G1,5,2),--RIGHT(G1,2)),TODAY(),"y")

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk

 

[Guest]

or

=DATEDIF(TEXT(G1,"0000-00-00"),TODAY(),"y")

With your downloaded DOB in G1 try:

=DATEDIF(DATE(--LEFT(G1,4),MID(G1,5,2),--RIGHT(G1,2)),TODAY(),"y")

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk

 

[Sandy Mann]

Yes - nice one!

--
Regards,

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk