Excel Macro enabled not accepting 2020 date

Question

I have a macro enabled spreadsheet that I have been using since 2015. As of Jan 1st 2020 it will not accept the date. Getting incorrect date format error. We are now 8 days behind on collecting charges. Need help asap. 

Thank you.

Answer 1

Do you have separate data validation on the column beyond default validation?

Can you upload a small, sanitized copy of the file so we can look at it directly

Upload Example - Trouble Shooting - Share Personal OneDrive File (not Business OneDrive)

.

Trouble shooting problems in files can be like a visit to the dentist, a long, slow painful process of us trying to “extract” the clues needed to recognize the problem in a back and forth flow of questions and answers so that we can come up with a / “the” solution.

.

Often it is faster and easier for everyone if we have a “sample file” get "hands on", to look at, and to “play with”.

.

This next link provides some tips on setting up a sample file and specific instructions for uploading and "sharing" it for us to access:

.

https://answers.microsoft.com/en-us/windows/forum/windows_other-winapps/trouble-shooting-share-onedrive-file/a231a097-bcbf-4e34-ad6c-a33118baf471

.

Includes links to macros to randomize text in Word and numbers in Excel

.

**************************************

.

The first 2 minutes of this video gives an example of What I mean by a “simple” example. Use short simple names and quantities, and just 2 or 3 rows per sample data you want calculations done on.  You want simple numbers so you can do the math checks in your head.

Col- **Stacking Columns of Data (Unpivot, Split Columns by delimiter, and everything!)****(PowerQuery)******2017 04 16

We’ve got headers and a large number of paired columns that need to be condensed down to just 2 columns. 

.

**************************************

.

Answer 2

Tried everything still gets error.

Answer 3

I have a macro enabled spreadsheet that I have been using since 2015. As of Jan 1st 2020 it will not accept the date. Getting incorrect date format error. We are now 8 days behind on collecting charges. Need help asap. 

Thank you.

Answer 4

In the sheet, Formulas>Auditing........... used the various options?