retrieving last two digits from a date value

I

Ify

Hi
Many thanks for your last respond on current date and username value
on cell. The problem with that was the procedure does not function on
shared workbook. Infact, the workbook is not even seen from the V
editor when on shared. Any further idea?

Another issue I have is this:

How can I use left ,right functions or any other formular to retriev
the last two digits from the following
date values:
apr-2003,
may-2003
apr-2004
may-2004
I want the result to be just 03,04 etc.

I do not want to use format cell from the format menu. Rather
formual.
When I use left or right formula, it gives me some numbers that i don'
need.

Any idea please
 
R

Rollin_Again

How about:

If you have *apr-2003* in Cell A1 try the following formula in cell B1

=RIGHT(YEAR(A1),2



Rolli
 
Top