Displaying Dates

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Khalil Handal - 17 Feb 2007 12:45 GMT

Hi to all,
Sheet1 has a value in cell G14 represent the years of a date
I want to copy it to sheet3 in th same location G14 but only to display 2
digits (1993 will show as 93) and 2007 will show 07 and 2000 will show 00)

G14 in sheet3 will show nothing if no value is entered in G14 in sheet1

Thanks

Reply to this Message

Max - 17 Feb 2007 13:51 GMT

In Sheet3's G14:
=IF(Sheet1!G14="","",TEXT(RIGHT(Sheet1!G14,2)+0,"00"))

Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

> Hi to all,
> Sheet1 has a value in cell G14 represent the years of a date
[quoted text clipped - 4 lines]
>
> Thanks

Reply to this Message

MartinW - 17 Feb 2007 14:13 GMT

Hi Khalil,

If your input in sheet one is numeric then
=IF(Sheet1!G14="","",RIGHT(Sheet1!G14,2))

If your input in sheet one is date then
=IF(Sheet1!G14="","",RIGHT(YEAR(Sheet1!G14),2))

HTH
Martin

Reply to this Message

Khalil Handal - 17 Feb 2007 15:04 GMT

Note: Sheet1 containes only numbers: 1992 , 2000 ...
Thanks to both of you. It worked well.
Khalil

> Hi Khalil,
>
[quoted text clipped - 6 lines]
> HTH
> Martin

Reply to this Message