Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to convert a month to a quarter ...... | New Users to Excel | |||
Date formulas | Excel Discussion (Misc queries) | |||
Mileage Claim Formula | New Users to Excel | |||
Imported Date & Time format with calcs. managed in excel from imrp | Excel Worksheet Functions | |||
imported impromtu report date issue - fix by format or formula | Excel Discussion (Misc queries) |