Excel date formula doesn't work past the new year
Closed
PaiviM
Posts
8
Registration date
Friday December 1, 2017
Status
Member
Last seen
December 30, 2017
-
Updated on Dec 29, 2017 at 05:02 PM
PaiviM Posts 8 Registration date Friday December 1, 2017 Status Member Last seen December 30, 2017 - Dec 30, 2017 at 11:36 AM
PaiviM Posts 8 Registration date Friday December 1, 2017 Status Member Last seen December 30, 2017 - Dec 30, 2017 at 11:36 AM
Related:
- Excel date formula doesn't work past the new year
- Date formula in excel dd/mm/yyyy - Guide
- Number to words in excel formula - Guide
- Excel grade formula - Guide
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Transfer data from one excel worksheet to another automatically formula - Guide
2 responses
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Dec 29, 2017 at 02:26 PM
Dec 29, 2017 at 02:26 PM
Paivi, Good afternoon.
Analyzing your situation, the result is very strange.
The formula is correct.
I suppose the cells Z3 and AA3 are formatted as DATE.
I also suppose that when entering the date you have typed as date and there being no possibility of entering as text.
Try doing the same procedure using other cells.
Example:
AC10 as the cell of the original date.
AD10 as the formula cell.
Format AC10 and AD10 as dates.
Enter the date.
Does the same problem happen ???
Do this and tell us the result.
We will be here and we will try to help you.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Analyzing your situation, the result is very strange.
The formula is correct.
I suppose the cells Z3 and AA3 are formatted as DATE.
I also suppose that when entering the date you have typed as date and there being no possibility of entering as text.
Try doing the same procedure using other cells.
Example:
AC10 as the cell of the original date.
AD10 as the formula cell.
Format AC10 and AD10 as dates.
Enter the date.
Does the same problem happen ???
Do this and tell us the result.
We will be here and we will try to help you.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Dec 29, 2017 at 03:18 PM
Dec 29, 2017 at 03:18 PM
Paivi,
"...Could it be because it's Excel online? ..."
I do not think it would make any sense if it happened.
It is a basic operation.
And you're using EXCEL, with the only difference being the online version.
Did you try to open a new worksheet and do the same test?
Here's the example I made for you using Excel 2007 (it's what I have).
https://www.sendspace.com/file/nm6mvf
I'll wait for your news.
--
Belo Horizonte, Brasil.
Marcílio Lobão
"...Could it be because it's Excel online? ..."
I do not think it would make any sense if it happened.
It is a basic operation.
And you're using EXCEL, with the only difference being the online version.
Did you try to open a new worksheet and do the same test?
Here's the example I made for you using Excel 2007 (it's what I have).
https://www.sendspace.com/file/nm6mvf
I'll wait for your news.
--
Belo Horizonte, Brasil.
Marcílio Lobão
PaiviM
Posts
8
Registration date
Friday December 1, 2017
Status
Member
Last seen
December 30, 2017
Dec 30, 2017 at 11:36 AM
Dec 30, 2017 at 11:36 AM
Hi,
I've downloaded the spreadsheet as it's stored in O365 as a shared document. The formula on the download works fine and gives the dates for 2018. I've created the formulas on the shared document and have access to update it on the browser (allows to make quick changes) but not on the "edit in Excel" option which would give full functionality of the spreadsheet. They are migrating from google docs and that stops me from accessing the "edit in excel" as I'm an outside contractor and work from home.
Kind regards,
Paivi
I've downloaded the spreadsheet as it's stored in O365 as a shared document. The formula on the download works fine and gives the dates for 2018. I've created the formulas on the shared document and have access to update it on the browser (allows to make quick changes) but not on the "edit in Excel" option which would give full functionality of the spreadsheet. They are migrating from google docs and that stops me from accessing the "edit in excel" as I'm an outside contractor and work from home.
Kind regards,
Paivi
Dec 29, 2017 at 03:02 PM
Thank you for your quick reply. Yes unfortunately, the problem is still there. I've checked that the formatting is definitely as date. Could it be because it's Excel online? I'm totally baffled by this, and worry I won't be able to give an answer to my client.
Kind regards,
Paivi