I am trying to pull a bunch of dates from one sheet to another, but sometimes, there is no date to be entered so I would like that cell to be blank. Every time I do the formula, it comes back with a date of 1/0/1900. I need this to be a blank cell. Can anyone help with this? Here is the formula I'm using.