Available Days

[Andreas_Ramelsberger]

Hey all,

I am working on a app where I calculate a project time. So from START to END Date… Now I want to make a math, where I calculate how much days are remaining? Do you have any recommendation for me?

The second thing is. I want to calculate the availablilty of all users per week. That means 5 working days per week… In a project table I have a start and end date… how can I do a Math table to calculate start to end MINUS the weekend days?

Thanks for your help
Andi

[ThinhDinh]

@Andreas_Ramelsberger

So from START to END Date… Now I want to make a math, where I calculate how much days are remaining? Do you have any recommendation for me?

So you just need a math column with a formula like:

TRUNC(E-N)

With E being the End date and N being the “now” value.