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

  • Thread starter Thread starter Sandy Mann
  • Start date Start date
S

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
 
or

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

Sandy Mann said:
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
Click to expand...
 
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
 
Back
Top