Google Sheets – Calculate Minimum Date Between Cell and TODAY()

google sheets

I need to calculate the minimum date between a cell and TODAY, but somehow the MIN function is failing me. Here's the demonstration.

If I calculate it on a range, such as =min(A1:A2) it works, but I need to do it inline, I don't have a range to check. If I try to calculate it on comma separated values, it returns an integer =min(A1,TODAY()) –> 41824 ?

I'm puzzled, what am I missing?

Best Answer

41824 is Google's date serial number for July 4, 2014 - can be formatted as Date to see this. (The minimum date from today, if not yet reached, would seem always to be the maximum - most recent - date.)

Select the cell and click "Format -> Number -> Date".

Related Solutions

Google Sheets – Non-Deterministic Parameters to Custom Function

I've made some research and it seems like an old problem, even from old MS Excel versions.

I think the best/easiest way is to create your own randomization function. This way random value won't be regenerated. You use it the same way as before =plusOne(myRandom())

function plusOne(i) {
  return i + 1;
}

function myRandom() {
  # Some function
  return Math.random();
}

You could also shorten it =myRandom()

function myRandom() {
  # Some function
  return Math.random() + 1;
}

Google-sheets – Filter by Date Range in Google Spreadsheets

UPDATE: Today Google added filtering conditions to Google Sheets.

~~At this time the filter feature of Google Sheet doesn't include date range filtering~~.

References
Filter you data - Docs editors help
Google Sheets: Do more with your data - Google Docs Blog

Best Answer

Related Solutions

Google Sheets – Non-Deterministic Parameters to Custom Function

Google-sheets – Filter by Date Range in Google Spreadsheets

Related Topic