Forum Discussion

ChrisSwirtz1's avatar
ChrisSwirtz1
Qrew Trainee
20 hours ago
Solved

Calculating number of days between two date fields

This is probably a super easy question but I am rusty and nothing I am trying is working and all the discussions I am finding are asking for more complicated formulas. I simply need to calculate the...
formulas
  • MarkShnier__You's avatar
    MarkShnier__You
    20 hours ago

    np!

    Just make a formula numeric field with the formula

    [End Date] - [Start Date]

    If you want he  number of Business Days, then there is a function for that.

    WeekDaySub([End Date], [Start Date])

ChrisSwirtz1's avatar
ChrisSwirtz1
Qrew Trainee
20 hours ago

Ok, I feel dumb... I swore I tried those very formulas and it didn't work, turns out it was because I accidently added one of the date fields as a text field and didn't realize it. Once I fixed that formula worked just fine, thanks!