title: Using the Mode function with dates (decimal data) in Excel
body: <p>I have a column of dates in Excel, and there will always be only two dates in the column.  I want a formula to return the date that exists most (so if 1/23/13 occurs 24 times and 1/24/13 occurs 72 times, I want the formula to return 1/24/13).</p>
  
  <p>I used the MODE formula across the range, and this worked for a couple days in a row, but today it did not work.  Upon further review, I realized the dates are really viewed by Excel as decimal numbers, and I imagine this is the problem.</p>
  
  <p>I could get to what I need by inserting a new column and filling it with <code>=TRUNC(cell)</code> for all cells in the range, and then applying the MODE formula to the new column, but I'm hoping there might be a way to do it without introducing a new column or formulas.  Is it possible to do something like <code>=MODE(TRUNC(range))</code>?  That specific formula didn't work, but I'm hoping something similar will.</p>