Tenure in months

Erick Gutierrez

I am very new to Smartsheet, and I'm trying to enter a formula from an Excel spreadsheet: =DATEDIF(C2,NOW(),"m"). I'm basically trying to determine the tenure in months, C2 is the Hire date

Nic Larsen

You could try something like this, just update for for your column name. Might want to try Roundup as well, not sure which would better suit your needs:

=ROUNDDOWN((TODAY() - [Date of Hire]@row) / 30)

Nic Larsen

It is, you can try this one as well. I forget about the INT one, but this may be better:

=INT((TODAY() - [Received by AA]3) / 30)

Nic Larsen

You could try something like this, just update for for your column name. Might want to try Roundup as well, not sure which would better suit your needs:

=ROUNDDOWN((TODAY() - [Date of Hire]@row) / 30)

Erick Gutierrez

That worked! Thank you!

Erick Gutierrez

Is it essentially "rounding" the months? As I notice a slight difference on the months in Excel vs Smartsheet.

Nic Larsen

It is, you can try this one as well. I forget about the INT one, but this may be better:

=INT((TODAY() - [Received by AA]3) / 30)