How can I convert this column into a date with the format MM/DD/YYYY?

Options

I used the formula - =(([Hire Date]@row - [Term Date]@row) / 365) / 12

• ✭✭✭✭✭✭
Options

What would the date be? If you subtract a date from a date you are left with a number of days. Dividing the number of days by 365 gives you a fraction of a year. I'm not sure what the dividing by 12 does. What date would you expect -0.09018 to be?

• Options

I tried to play around with the formula and divided it by 12 because I was expecting 1 year to display based on the date range. For example, 4/1/23 to 5/1/23 should reflect 1 month. Thanks!

• ✭✭✭✭✭✭
Options

When you subtract one date from another, the result will be in days.

So 5/1/23 minus 4/1/23 will equal 30.

When you say you want it in MM/DD/YYYY format, how would it be displayed? Can you give a few examples?

5/1/23 minus 4/1/23 would be ....

5/1/23 minus 4/30/23 would be ...

5/1/23 minus 3/1/23 would be ...

8/1/23 minus 4/30/23 would be ...

1/1/23 minus 1/1/24 would be ...

1/1/23 minus 1/1/25 would be ...

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!