Rankadv dates, or DATEVALUE

Rsparks

Hi,

I was trying to rankadv a series of dates (to calculate employee seniority), which isn't yet a feature. Since I cannot do that, I wanted to turn that date into a number that I could then rank, which in Excel I can do with the DATEVALUE function. Is it possible to get either of those in SmartSheets?

 

Paul Newcome

You can turn a date into a number with the YYYYMMDD format like so:

=VALUE(YEAR([Date Column]@row) + "" + RIGHT("0" + MONTH([Date Column]@row), 2) + RIGHT("0" + DAY([Date Column]@row), 2))