Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 49
Default How to use a right formula on a date-format

Hi everybody,

My problem is this. I have a lot of cells containing dates 06-06-2006
etc. They are in a date format. I want the next column to only return
the year i.e. 2006 in the above exampel. I tried the right formula -
but that only returns the corresponding number (corresponding to the
date) - any ideas?

Regards
Heine

  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 11,058
Default How to use a right formula on a date-format

Use =YEAR(A1) rather than =RIGHT(A1,4). If you want to use RIGHT then you
must also use TEXT.
--
Gary's Student


"Heine" wrote:

Hi everybody,

My problem is this. I have a lot of cells containing dates 06-06-2006
etc. They are in a date format. I want the next column to only return
the year i.e. 2006 in the above exampel. I tried the right formula -
but that only returns the corresponding number (corresponding to the
date) - any ideas?

Regards
Heine


  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 49
Default How to use a right formula on a date-format

Thanks - much better idea. Works like a charm.

Best regards

Heine
Gary''s Student wrote:
Use =YEAR(A1) rather than =RIGHT(A1,4). If you want to use RIGHT then you
must also use TEXT.
--
Gary's Student


"Heine" wrote:

Hi everybody,

My problem is this. I have a lot of cells containing dates 06-06-2006
etc. They are in a date format. I want the next column to only return
the year i.e. 2006 in the above exampel. I tried the right formula -
but that only returns the corresponding number (corresponding to the
date) - any ideas?

Regards
Heine



  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 11,058
Default How to use a right formula on a date-format

You are very welcome!

The alternative is:
=RIGHT(TEXT(A1,"mm/dd/yyyy"),4)
--
Gary's Student


"Heine" wrote:

Thanks - much better idea. Works like a charm.

Best regards

Heine
Gary''s Student wrote:
Use =YEAR(A1) rather than =RIGHT(A1,4). If you want to use RIGHT then you
must also use TEXT.
--
Gary's Student


"Heine" wrote:

Hi everybody,

My problem is this. I have a lot of cells containing dates 06-06-2006
etc. They are in a date format. I want the next column to only return
the year i.e. 2006 in the above exampel. I tried the right formula -
but that only returns the corresponding number (corresponding to the
date) - any ideas?

Regards
Heine




  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 620
Default How to use a right formula on a date-format

And that is presumably just the same as =TEXT(A1,"yyyy") ?
--
David Biddulph

"Gary''s Student" wrote in message
...
You are very welcome!

The alternative is:
=RIGHT(TEXT(A1,"mm/dd/yyyy"),4)
--
Gary's Student


"Heine" wrote:

Thanks - much better idea. Works like a charm.

Best regards

Heine


Gary''s Student wrote:
Use =YEAR(A1) rather than =RIGHT(A1,4). If you want to use RIGHT then
you
must also use TEXT.
--
Gary's Student


"Heine" wrote:

Hi everybody,

My problem is this. I have a lot of cells containing dates 06-06-2006
etc. They are in a date format. I want the next column to only return
the year i.e. 2006 in the above exampel. I tried the right formula -
but that only returns the corresponding number (corresponding to the
date) - any ideas?

Regards
Heine






Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to convert a month to a quarter ...... Epinn New Users to Excel 26 May 3rd 23 07:45 PM
Date formulas DRondeau Excel Discussion (Misc queries) 7 September 6th 06 09:53 PM
Mileage Claim Formula johndavies New Users to Excel 4 August 14th 06 09:24 AM
Imported Date & Time format with calcs. managed in excel from imrp Todd F. Excel Worksheet Functions 0 July 8th 05 09:03 PM
imported impromtu report date issue - fix by format or formula Todd F. Excel Discussion (Misc queries) 3 July 7th 05 09:57 PM


All times are GMT +1. The time now is 11:01 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"