Forum Discussion

lisaa100's avatar
lisaa100
Copper Contributor
May 17, 2021
Solved

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

Hi there!   I'm a novice, so bear with me. Numbered items below in green are working just fine, items in red are what I'm having issues with:   L7 has formula =N7-M7 However, I want for cells i...
excel
  • HansVogelaar's avatar
    HansVogelaar
    May 17, 2021

    lisaa100 

    In L5:  =IF(COUNTA(M5:N5)<2,"",N5-M5)

    In J5:   =IF(COUNTA(K5,N5:M5)<3,"",N5-M5-K5)

     

    Fill down.

HansVogelaar's avatar
HansVogelaar
MVP
May 17, 2021

lisaa100 

In L5:  =IF(COUNTA(M5:N5)<2,"",N5-M5)

In J5:   =IF(COUNTA(K5,N5:M5)<3,"",N5-M5-K5)

 

Fill down.

lisaa100's avatar
lisaa100
Copper Contributor
May 17, 2021
Sweet! That worked, thanks a bunch!

Resources