SOLVED

Empty date cells shows as 01/01/1900, but I want them left blank

Copper Contributor

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)
  • 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

 

I then want to add some conditional formatting so that these highlight red when they are due/overdue.  Thinking of making the text white then (highlight cell rules > less than todays date)

 

This is driving me mad!  I've looked at other similar questions, but they all seem too complex.

 

Any help is greatly appreciated!

3 Replies
best response confirmed by Robo100 (Copper Contributor)
Solution

@Robo100 Perhaps this?

=IF(F3="","",F3+7)

 

That is great! Thank you SO much!!

@Robo100 

 

=if(isblank(F3)," ",F3+7)

1 best response

Accepted Solutions
best response confirmed by Robo100 (Copper Contributor)