Search results
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 maj 2021 · Maybe Excel has a bug in how dates are handled in Scatter charts. 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.
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.
30 sty 2023 · However, I want for cells in that column to be blank when N7 and/or M7 are empty. 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.
8 cze 2020 · In the cells filled with red, the formula returns C5 to C8 all of which are blank and seen by Excel as having a value of 0. That date serial number when formatted as a date "yyyy-mm-dd" is 1900-01-00.
Have you double checked that your dates are actually dates and not text? ISNONTEXT(date) will return FALSE if it is text. Also, are there blank dates in your date ranges? If you have a calculation based around a blank, it could be returning 0, which date formats to Jan 1900.
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?
