Calculating 90 days from a date

907sam

How do I calculate 90 days from someone's hire date?

Column Name: Hire date 01/03/2023

Formula I am trying to use: ==[Hire Date]@row + 90

This is coming back as 01/03/202390 which is wrong. It should be 4/3/23

Jaime M.

Hi!

I would add a helper column for the "Day Until Next Review" and reference this in your equation instead. You could add an automation to automatically put 90 in the "Day Until Next Review" column, or alternatively, make it the default value in a form - depending on how you are entering the information.

=[Hire Date]@row + [Days Until Next Review]@row

Hope this helps!

Peggy Parchert

@907sam

Hello - hope you are well. You show two "=" in your formula above. Is that correct? Is your Hire date column a date column?

Peggy