1,105,417 Community Members

Reference a cell with a date

Member Avatar
Divinedar
Light Poster
43 posts since Oct 2009
Reputation Points: 12 [?]
Q&As Helped to Solve: 0 [?]
Skill Endorsements: 0 [?]
 
0
 

I am trying to reference a cell with a date from one worksheet to the other. I am using ='Statistics MVP'!A16 but it doesn't give me the date format it just gives me the number 41125 or any other number. When I format as a date form I get 1/0/1900 and this is what I want to hide until a date is put in any cell that is being referenced. What I want is that if there is no date in cell A16 that I am referencing, I don't want it to show anything until a date is put in cell A16 but still show in date format. Any ideas anyone? Hope you understand.

I know how to hide zeros using 0;-0;;@ but it doesn't seem to be a way to use it in leu of the date format.

Member Avatar
tinstaafl
Postaholic
2,012 posts since Jun 2010
Reputation Points: 559 [?]
Q&As Helped to Solve: 402 [?]
Skill Endorsements: 35 [?]
 
0
 

try this function =IF(Sheet2!A1 = 0," ",Sheet2!A1) basically if the source = 0 then use a " " as the value otherwise use the value from the source.

Question Answered as of 1 Year Ago by tinstaafl
Member Avatar
Divinedar
Light Poster
43 posts since Oct 2009
Reputation Points: 12 [?]
Q&As Helped to Solve: 0 [?]
Skill Endorsements: 0 [?]
 
0
 

Perfect thank you.

You
This question has already been solved: Start a new discussion instead
Post:
Start New Discussion
Tags Related to this Article