title: Get display value from referenced cell instead of Julian date?
body: <p>I am trying to find out how to stop a formula from changing the date value to Julian date when referencing a date field.</p>
  
  <p>This is what is happening:</p>
  
  <p><a href="https://i.stack.imgur.com/hB7Gi.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/hB7Gi.png" alt="enter image description here"></a></p>
  
  <p>This is what I want:</p>
  
  <p><a href="https://i.stack.imgur.com/wlxwk.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/wlxwk.png" alt="enter image description here"></a></p>
  
  <p>Is it possible in excel to get the display value of a cell instead of the text value of a cell?</p>