retrieving last two digits from a date value

  • Thread starter Thread starter Ify
  • Start date Start date
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
 
How about:

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

=RIGHT(YEAR(A1),2



Rolli
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Retrieving date values 1
Retrieving Date 1
VBA - retrieve data on last create named range from previous inserted named range 0
last negative cell 2
Retrieve cell value 3
change text to real dates 17
sort a cell by last two digits 4
How to change the year digit? 4

Back
Top