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.
 

Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce
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.
 
Upvote 0
The Portuguese equivalent for TEXT is TEXTO, and NOW is AGORA. You will need to use semicolons instead of commas as the argument separator.
 
Upvote 0

Forum statistics

Threads
1,213,510
Messages
6,114,037
Members
448,543
Latest member
MartinLarkin

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
Back
Top