Search results
12 sty 2018 · I've tried a few of Excel's standard date formats as well as one or two custom formats in the charts' source data, and have selected Date as the category in Axis Options (in Format Shape). Somehow, I gather, Excel's chart system is interpreting it all as strings, not dates.
26 maj 2021 · The problem was mine, not Excel's. I was plotting dates for morning, afternoon, and evenings, and so my columns had blank entries between dates. I discovered that any blank entry for a date causes the entire plot to start at 1900. Blanks shouldn't cause this.
9 maj 2022 · I have a spreadsheet that converts the date in one cell to a year in another. I want to pull the formula down so that it automatically shows the date in columns A and B if there is a date in column C; however, I do not want it to say 1900 on blank cells.
26 lis 2003 · Your dates are not dates but string entries. Convert them to be actual Excel dates and everything should work fine. One way to convert string entries to numeric is to type 1 in an empty cell, copy that cell, and paste it over the cells you want to convert using Edit/Paste Special/Multiply. You may need to format the cells as date again afterwards.
17 maj 2021 · Then, when user enters the values for N7 and M7, it provides calculated dates for L7 and J7. Cells with calculated dates are green if 30+ days from Today, yellow if less than 30 days from Today, and red if Today or past Today.
7 mar 2022 · When the cell in sheet 2 is empty, "1/0/1900" is of course displayed in sheet 1. But I need to hide or suppress the "1/0/1900" until such time that an actual date is put into the cell in sheet 2. How do I do this?
Excel supports two date systems, the 1900 date system and the 1904 date system. Each date system uses a unique starting date from which all other workbook dates are calculated. All newer versions of Excel calculate dates based on the 1900 date system, while older versions used the 1904 system.
