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.
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?
Wondering why I'm getting 1/0/1900 for blank cells. I have done my normal Index Match formula that I do usually, and I've never seen this before. My usual formula is this - =IFERROR(INDEX(Target!$D:$D,MATCH(Commercial!$B4,Target!$C:$C,0)),"")
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?
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.
11 gru 2013 · It will work if your dates are after 1st January 1900 (the zero point). Consequently if F5 =< 0 then display "". "" is standard notation for empty string of characters - so nothing gets displayed.
4 cze 2014 · I have a formula =VLOOKUP(C6,A1:C8,3,FALSE) which returns 1/9/1900 if the cell is blank. Which I think is because it returns a 0 value and the cell is formatted for a date. So I tried =IFERROR(VLOOKUP(C6,A1:C8,3,FALSE),"") hoping this would return a blank instead.
