Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Formula that allows me accrue a PTO day by month

Topic Labels: Formulas
1534 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Claudio_Fernand
4 - Data Explorer
4 - Data Explorer

Hi Everyone, I am trying to build a simple PTO tracker for my team. I have my list of employees and I would like to add a column with a formula that create 1 PTO day per month but I dont have clue on how to do it. Any help on this please?

Thanks!

3 Replies 3

If the requirement is just a simple incrementor that gains 1 in value each month, it should be pretty simple.

Assumptions:

  • You have a “Start Date” field where each team member’s start date with the team/company is indicated as a Date
  • You want the PTO value to increase by 1 for each month since the team member’s start date (implying everyone’s PTO will increment by 1 every month, but not necessarily on the same day – a team member who started on the 6th of the month will earn their PTO day on the 6th every month; a team member who started on the 27th of the month will earn their PTO day on the 27th every month, etc.)
IF(
  {Start Date},
  DATETIME_DIFF(TODAY(), {Start Date}, 'months')
)

Thanks so much Jeremy! it was so helpful. And one more question, what about for those employees who has 2 weeks per Year, which formula can I use to do a monthly accrual of this case? Thanks!

Vikas_Vimal2
6 - Interface Innovator
6 - Interface Innovator

Multiply the above formula by 0.833333333
Assuming 2 weeks/year is 10 days per year. Maybe use a round() or rounddown() formula to process it.