title: Excel DateTime To Date #VALUE! error using =INT()
body: <p><img src="https://i.stack.imgur.com/MmBae.png" alt="enter image description here"></p>
  
  <p>Hey, </p>
  
  <p>so I have a column on the left sample_datetime and a column on the right sample_date where i used "=INT(cell to the left)" to get the date only. but it is not getting a value when the date time format changes. and I'm not sure why this is?  ive tried changed the format of the cell (datetime) that doesnt turn out a date value to the same format as the one that does but the cell doesnt change. </p>
  
  <p>any ideas on what i can do? and the reason why it doesnt work </p>
  
  <p>01/12/2010  12:30:00 PM </p>
  
  <p>this is what the one that gets a date value looks like in the function bar 
  the format of the cell is dd/mm/yyyy h:mm</p>
  
  <p>1/13/1994 11:00:00</p>
  
  <p>this is what the one that does not get a date value looks like in the function bar
  the format of the cell is general</p>