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.
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?
11 lip 2019 · I have copied and pasted various times into an excel document, and changed the formatting to include the date. It defaults to 1/0/1900. I am doing this for many times and dates. How can I quickly fix the date without having to go into each cell?
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)),"")
23 paź 2012 · How do you convert a 1/0/1900 date to a blank? Also convert to a zero? 1/0/1900 is simply the way that Excel displays a date that is zero. If you want to see zero, format the cell as General or Number. On the other hand, Excel might be misleading you.
20 wrz 2023 · If F3 is empty the following is shown in H3 and J3 07/01/00 and 14/01/00 respectively, but I want these cells to be blank when F3 is empty. Then, when someone enters a date in F3, it provides calculated dates for H3 & J3.
