Marţi, 15 februarie 2022
  1 Răspunsuri
  5.8K vizite
0
Voturi
Anula
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, aaaa-ll-zz.

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
de ani în urmă 2
·
#2471
0
Voturi
Anula
Hi Bill,

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

Amanda
  • Pagina:
  • 1
Nu există răspunsuri făcute pentru acest post.