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 · Call them sheet "1" and "2". A particular cell in sheet 1 references (pulls from) a particular cell in sheet 1. Both cells in both sheets are "date" formatted. When the cell in sheet 2 is empty, "1/0/1900" is of course displayed in sheet 1.
17 maj 2021 · Hi, You can change the format of the cells by going to Format Cells > Customs and adding following [=0] ;dd-mm-yyyy . This will display a blank wherever the result is 0
9 lut 2004 · Replacing 00/01/1900 dates with blanks Hi, In a column ‘A’ on Sheet1 I have a list of dates (in the format dd/mm/yyyy) and I am using the formula in column ‘A’ on Sheet2 e.g. =Sheet1!A2 copied down the column to populate the same dates, however, if a cell is empty on Sheet1 it will report the date 00/01/1900 in the corresponding cell in ...
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).
20 wrz 2023 · Empty date cells shows as 01/01/1900, but I want them left blank. Hi! I'm a beginner, so please be patient! I have created a simple spreadsheet with names and dates: F3 is the formatted to dd/mm/yy. H3 has formula =F3+7 (1 week), J3 has the formula =F3+14 (2 weeks)
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;;
