Search results
9 maj 2022 · =IF(C27=0,"",TEXT(C27,"YYYY")) should work - excel treats empty cells as equal to zero. So if it's equal to zero, this formula returns an empty string (""), which makes the cell look blank, if not then it returns TEXT(C27,"YYYY")
17 maj 2021 · L7 has formula =N7-M7 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.
7 mar 2022 · I tried formatting the sheet 1 cell as a "custom" and used the following: "1/0/1900";"1/9/1900";;@...and that successfully hides/suppresses the 1/0/1900, but the issue is when an actual date is put into the sheet 2 cell, the date format is gone in sheet 1.
20 wrz 2023 · H3 has formula =F3+7 (1 week), J3 has the formula =F3+14 (2 weeks) 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.
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)),"")
For a reason I can't find, my appropriate date of 12/31/16 in a date-defined cell shows as 1/0/1900. I have to put a single quote before for it to look correct, but then I have to treat it as text in formulas, or enter it as =date(2016,12,31).
15 mar 2022 · In the cells formatting, if you create a custom formatting with double semi colons, the date 00 January 1900 will be left as blank, for example, for your custom date format, use the value dd mmmm yyyy;;
