Extract the Date From the name

[shimaa01234]

Extraction of the date from the name and the length of the name Variable
In addition to the 24-month output

[oeldere]

See the green cell in the attached file.

The yellow cells are helpcells.

[shimaa01234]

WOW Mr "oeldere"
Yes, I want this, but I could not understand this formula
=LAATSTE.DAG(C3-1,24)+1
And This is formula too
=TEXT(E5,"jjjj-mm-dd")&" "&TEXT(F5,"uu:mm AM/PM")
Because I use Office 2003

[froment]

Those seem to be localized formulas in Dutch language... Try these:

=EOMONTH(C3-1,24)+1

=TEXT(E5,"yyyy-mm-dd")&" "&TEXT(F5,"hh:mm AM/PM")

[oeldere]

@froment

Yes they are in dutch but normaly excel should change the language automaticly.

[shimaa01234]

Can I change this formula to conform with Office 2003
=EOMONTH(C3-1,24)+1

[froment]

@froment

Yes they are in dutch but normaly excel should change the language automaticly.

It didn't change them for me, those two cells reported errors, and only when I edited them, they displayed values...

Can I change this formula to conform with Office 2003
=EOMONTH(C3-1,24)+1

I forgot about Office 2003, but quick Google search says that this function should be available in 2003, too, after activating Analysis Toolpak Addin; go to Tools - Addins, and try to locate it there and enable.

[Glenn Kennedy]

Has anyone answered the Op's question - which related to cell B3? i don't think so, so here's my offering... Looking for a simpler solution. Any takers...

[shimaa01234]

Solution genius my professor
Thank you very much, Mr. "Glenn"
God bless you

[Glenn Kennedy]

You're very welcome, Thanks for the Reputation.