About 258,000 results
Open links in new tab
  1. 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

    Empty Date Cell shows as 1/0/1900, but want it blank

    techcommunity.microsoft.com/t5/excel/empty-date-cell-shows-as-1-0-1900-but-want-it-blank/td-p/2362128
    techcommunity.microsoft.com/t5/excel/empty-date-cell-shows-as-1-0-1900-but-…
    Was this helpful?
  2. People also ask
    What if a date cell is blank?
    Assistance with this formula. If the date cell is blank, leave blank, otherwise if the date is less than today, give the difference in months: what if it is greater than or equal to today? There is a tiny mistake there. Thank you. Your suggestion worked. Really appreciate!!

    Excel IF with DATEDIF, when Date is blank - Super User

    superuser.com
    What happens if a date is empty in JavaScript?
    The answer is… nothing. If the date is empty, don’t do anything, return an empty value: null. No expression, no single quotes around it, just the string null. The third (and last) part is to define what should happen when the condition is false. That’s the place to format the date.

    How to format a date that can be empty (null) in Power Automate

    tomriha.com
    Why does a date return a null value?
    Here's why this works: If you select a date which is stored as 01/01/1900 but returns NULL, it will show as NULL in the result. This is why an ISNULL on the date field, while you're working with any date data type, will not treat this as a NULL, as it is technically not being stored as a NULL.

    Change NULL values in Datetime format to empty string

    stackoverflow.com
    How do I store a null in a DateTime object?
    Make you insert real nulls not strings, then the db will store a null. Ozi, when you create a new datetime object as in datetime foo = new datetime (); foo is constructed with the time datetime.minvalue () in building a parameterized query, you could check to see if the values entered are equal to datetime.minvalue ()

    Insert null/empty value in sql datetime column by default

    stackoverflow.com
    Feedback
  3. Microsoft Community
    https://answers.microsoft.com › en-us › msoffice › forum › ...

    Returning a date in a cell, but leave blank if no date entered

    =DATEDIF & ISBLANK TOGETHEROct 31, 2024
    My computer does not automatically update time & date.May 16, 2017
    when i hover over calendar i have nothing scheduled todaySep 9, 2013
    Unable to remove the calendar reminder appointment.Jul 11, 2013
    See more results
    Tags:
    Empty Date
    Microsoft Excel
    Formal Date in Cell When Blank
  4. The Tableau Community
    https://community.tableau.com › question

    Replacing date value Null with blank or zero - The …

    Jan 17, 2017 · Some dates are showing as 'blanks' and I want these values left in the vis and not filtered out. But rather than "Null", I want to show this as another text value, or a blank. I have tried IFNULL, IF ISNULL, ZN, LOOKUP and …

    Tags:
    Data Visualization
    Replace Null Date with Zero
    Tableau Remove Null in Date Field
  5. Microsoft Community
    https://techcommunity.microsoft.com › e…

    Conditional Formatting if date is past And Cell is Blank

    May 12, 2020 · Am trying to find a formula that works if a date is past today's date and the another cell is blank to highlight the date cell red, until the blank cell is filled.

    Tags:
    Microsoft Excel
    Formal Date in Cell When Blank
    Conditional Format Cells Not Blank
  6. Microsoft Fabric Community
    https://community.fabric.microsoft.com › Desktop › ...

    Solved: IF function when Date is empty - Microsoft Fabric …

    Solved: Displaying a Blank for a Date CalculationFeb 7, 2021
    Solved: DateAdd returns blank valuesAug 14, 2016
    See more results
    Tags:
    Empty Date
    Function
  7. Stack Overflow
    https://stackoverflow.com › questions

    sql - Convert NULL datetime to Blank - Stack Overflow

    Insert null/empty value in sql datetime column by defaultAug 27, 2016
    Change NULL values in Datetime format to empty string
    See more results
    Tags:
    Sql Null Datetime
    Convert Null Date To Blank Sql
    Sql Date Is Null Or Empty
  8. Super User
    https://superuser.com › questions

    Excel IF with DATEDIF, when Date is blank - Super User

  9. Let's POWER Automate
    https://tomriha.com › how-to-format-a-date-that-can...

    How to format a date that can be empty (null) in Power Automate

    Tags:
    Empty Date
    Power Automate Formatdatetime If Null
    Power Automate Blank Date
  10. Spreadsheet Planet
    https://spreadsheetplanet.com › using-if …

    Using IF Function with Dates in Excel (Easy Examples)

    Learn how to use the IF function with dates in Excel with easy examples. Compare dates, use operators and DATEVALUE and TODAY functions.

    Tags:
    Microsoft Excel
    Comparing Dates in Excel
    Date If Functions
  11. microsoft.com
    https://techcommunity.microsoft.com › excel

    Empty Date Cell shows as 1/0/1900, but want it blank

  12. superuser.com
    https://superuser.com › questions

    microsoft excel - Don't show 1900 on blank date - Super User