Age calculation in format mmddyyyy without "/"

jscorrea

New Member
Joined
Feb 13, 2004
Messages
2
Hi all...this is my first post and my english is bad..

How do a calculate the age with the date of born in this format?:

12042003

In other words without the " / ".

In the conventional way (mm/dd/yyyy) I use the following formula :

Code:
=DATADIF(DATE;NOW();"Y")&" "


Thanks all for a little help.
 

Some videos you may like

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.

GS2000

New Member
Joined
Dec 26, 2002
Messages
20
Above solution is neater and shorter but this also works


=DATEDIF((LEFT(A2,2)&"/"&MID(A2,3,2)&"/"&RIGHT(A2,4)),NOW(), "Y")

assumes you have date in A1, formated as text and always ddmmyyyy

so if you want 1st jan 2004 must be 01012004 not 112004 ok?

Replace ref to cell/Col A etc to suit your needs.
 

jscorrea

New Member
Joined
Feb 13, 2004
Messages
2
Really Thanks for all...but the problem is my Excel in Portuguese so the expression is not the same...

Please send me a email for this example (or link)..

jscorrea@uol.com.br
 

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
The Portuguese equivalent for TEXT is TEXTO, and NOW is AGORA. You will need to use semicolons instead of commas as the argument separator.
 

Watch MrExcel Video

Forum statistics

Threads
1,127,405
Messages
5,624,574
Members
416,036
Latest member
eloisa manzanarez

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top