ChicagoGuy
New Member
- Joined
- May 12, 2017
- Messages
- 14
I have an odd problem that has been plaguing me on a particular spreadsheet. I am hoping there is some funky setting somewhere that fix this that I have somehow screwed up.
I have continual problems with date functions. Its as if the sheet will not recognize a data as a date. Its truly bizarre and it has come up in multiple attempts at different functions using dates. Today glitch is so simple but it will not work. Here is the funny thing. It WILL work if I open a NEW spreadsheet on my office computer. But it WILL NOT work on my office computer on my current spreadsheet.
So the formula works but not the spreadsheet. Again the one I am showing you below is simple but i have tried others in the process of building this and they have also acted very odd. Forexample I cannot use Today() to calculate anything.
OK here is what I am trying to do. The first table shows what a new spreadsheet gets and the second table show what my current spreadsheet gets. Help me Obi Wan
Using the following formula =MIN(H32:H38) I get 3/21/17 in the new spreadsheet[TABLE="width: 500"]
<tbody>[TR]
[TD]8/1/2017[/TD]
[/TR]
[TR]
[TD]3/21/17[/TD]
[/TR]
[TR]
[TD]4/11/2017[/TD]
[/TR]
[TR]
[TD]4/18/2017[/TD]
[/TR]
[TR]
[TD]4/11/2017[/TD]
[/TR]
</tbody>[/TABLE]
Here is the result using the same formula on my current spreadsheet
Using the following formula =MIN(H32:H38) I get 1/0/1900[TABLE="width: 500"]
<tbody>[TR]
[TD]8/1/2017[/TD]
[/TR]
[TR]
[TD]3/21/17[/TD]
[/TR]
[TR]
[TD]4/11/2017[/TD]
[/TR]
[TR]
[TD]4/18/2017[/TD]
[/TR]
[TR]
[TD]4/11/2017[/TD]
[/TR]
</tbody>[/TABLE]
Both are properly formatted as dates. You clearly see the current spreadsheet is not only failing its giving me a date that isnt possible. Its driving me nuts and I cannot figure what is going on. How could the dates effectively be turned off? How could I even get a date that have 0 in it.
It probably doesnt matter since both the working one and the non working one are both same but the excel version is excel20163 (15.0.4859.1000) MSO (15.0.4919.1002) 32but
I have continual problems with date functions. Its as if the sheet will not recognize a data as a date. Its truly bizarre and it has come up in multiple attempts at different functions using dates. Today glitch is so simple but it will not work. Here is the funny thing. It WILL work if I open a NEW spreadsheet on my office computer. But it WILL NOT work on my office computer on my current spreadsheet.
So the formula works but not the spreadsheet. Again the one I am showing you below is simple but i have tried others in the process of building this and they have also acted very odd. Forexample I cannot use Today() to calculate anything.
OK here is what I am trying to do. The first table shows what a new spreadsheet gets and the second table show what my current spreadsheet gets. Help me Obi Wan
Using the following formula =MIN(H32:H38) I get 3/21/17 in the new spreadsheet[TABLE="width: 500"]
<tbody>[TR]
[TD]8/1/2017[/TD]
[/TR]
[TR]
[TD]3/21/17[/TD]
[/TR]
[TR]
[TD]4/11/2017[/TD]
[/TR]
[TR]
[TD]4/18/2017[/TD]
[/TR]
[TR]
[TD]4/11/2017[/TD]
[/TR]
</tbody>[/TABLE]
Here is the result using the same formula on my current spreadsheet
Using the following formula =MIN(H32:H38) I get 1/0/1900[TABLE="width: 500"]
<tbody>[TR]
[TD]8/1/2017[/TD]
[/TR]
[TR]
[TD]3/21/17[/TD]
[/TR]
[TR]
[TD]4/11/2017[/TD]
[/TR]
[TR]
[TD]4/18/2017[/TD]
[/TR]
[TR]
[TD]4/11/2017[/TD]
[/TR]
</tbody>[/TABLE]
Both are properly formatted as dates. You clearly see the current spreadsheet is not only failing its giving me a date that isnt possible. Its driving me nuts and I cannot figure what is going on. How could the dates effectively be turned off? How could I even get a date that have 0 in it.
It probably doesnt matter since both the working one and the non working one are both same but the excel version is excel20163 (15.0.4859.1000) MSO (15.0.4919.1002) 32but