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.
17 maj 2021 · 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.
Since the cells you are reading are blank, you get a value of 0, which is why the date shows as it does. To fix that, you can check the return for blanks, though I'm not sure why you are using INDEX/MATCH when VLOOKUP will work:
24 mar 2022 · My formula under year is =YEAR(Date cell), but I not sure why the empty cell is showing as 1900? How to change the formula to show empty if there's no input in date? Thank you
21 sty 2022 · Everything works fine except for a couple of rows. Excel is showing those as a 0 rather than a blank cell, so instead of giving me "No new date" as the output, it gives me a 1/0/1900. The format of the column is short date. If I change it to general, it shows a 0. How can I fix this?
12 kwi 2009 · I am trying to reference a cell on another worksheet, the cell is formatted to be a date. when i put in the following formula =Sheet2!A1 and i don't input a date into A1 on sheet 2 the cell containing the formula shows the date 00/01/1900, is there any way of stopping this showing, ideally the cell would be blank until I inputted a date into A1 ...
6 wrz 2005 · Column R of Sheet1 contains the formula =XLOOKUP(A2,data!$A$2:$A$100,data!$E$2:$E$100,"-") The result from a blank cell (in column E) on the data tab is "1/0/1900". I need this to display "-" in the cell if there cell on the data tab is blank.
