How to have a date field automatically calculate 180 days from a previous date field

  • 1
  • 1
  • Question
  • Updated 2 years ago
  • Answered
I want to be able to have a formula calculate a new hire's end of probation date automatically based on the start date I enter in a previous date field.  The new hire will be scheduled off probation 180 days from their start date. Right now I have two date fields. I put in the date on the first one, but I don't know how to get the second date field to calculate automatically.
Photo of Nicole

Nicole

  • 30 Points

Posted 2 years ago

  • 1
  • 1
Photo of dwhawe

dwhawe, Champion

  • 744 Points 500 badge 2x thumb
The field for end of probation would be a formula - date field adding 180 days to your Start Date or whatever it is named:

[Start Date]+Days(180)
Photo of Nicole

Nicole

  • 30 Points
Thanks so much for the quick response! So does the "start date" need to be a Formula - Date field as well?
Photo of Nicole

Nicole

  • 30 Points
Never mind! Just got it to work! You're my hero! Come sit next to me at my desk so I can finish the rest please! Lol
Photo of dwhawe

dwhawe, Champion

  • 744 Points 500 badge 2x thumb
Happy to help.