| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I edit the year in a date field in Excel?
I have column in Excel that is formated as for dates. I need to change just
the year. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How can I edit the year in a date field in Excel?
Hi David,
you can use find and replace, or, send us more information regards from Brazil Marcelo "David Denham" escreveu: I have column in Excel that is formated as for dates. I need to change just the year. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How can I edit the year in a date field in Excel?
Hello David,
to add a year to a given date in A1 use =DATE(YEAR(A1)+1,MONTH(A1),DAY(A1)) Regards, Ingolf David Denham schrieb: I have column in Excel that is formated as for dates. I need to change just the year. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date format issue | New Users to Excel | |||
| EXCEL LOOKUP FISCAL YEAR WITH DATE | Excel Worksheet Functions | |||
| Exporting a date field in Excel to an Outlook Calendar? | Excel Discussion (Misc queries) | |||
| Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
| Syntax Error in Excel Query for DATE field | Excel Discussion (Misc queries) | |||
Linear Mode
