Skip to main content
Support is Offline
Today is our off day. We are taking some rest and will come back stronger tomorrow
Official support hours
Monday To Friday
From 09:00 To 17:30
  Tuesday, 15 February 2022
  1 Replies
  5.5K Visits
0
Votes
Undo
Hello.  I am trying to link a field in one worksheet from another worksheet within the same workbook (file).  They both have Date formats and the formula works well with a proper date inserted and using the formula ='Source Worksheet'C2!, in the resultant workbook field.  However, when the source field is blank I get the following in the resultant field, 1900-01-00.  Both fields use the same format for Date, yyyy-mm-dd.

How may I link the two fields and have a blank field as a result if the Source Field is empty?

Thanks & Best Regard, Bill
2 years ago
·
#2471
0
Votes
Undo
Hi Bill,

You can add the IF and ISBLANK functions to the target cell: =IF(ISBLANK('Source Worksheet'C2!),"",'Source Worksheet'C2!)

Amanda
  • Page :
  • 1
There are no replies made for this post yet.