Note: The other languages of the website are Google-translated. Back to English
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
  2.9K Visits
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
11 months ago
Hi Bill,

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

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

Follow Us

Copyright © 2009 - | All rights reserved. Powered by ExtendOffice. | Sitemap
Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.
Protected by Sectigo SSL