Forum Discussion
Anonymous
2 years agoNot applicable
Custom Column Duration.Days (include first day)
Hello
I am trying to create a custom column to show the difference in days between 2 dates.
I need to include the first date in the count
Ex
pcreatedon: 12/5/2023
createdon: 12/6/2023
I need this to show as 2 instead of the 1 day difference we usually use.
I am using:
Duration.Days([pcreatedon]-[createdon])
How do I get the count to show 2??
Anonymous
try to add +1 in the end
Duration.Days([pcreatedon]-[createdon]) +1
2 Replies
- ryan_mayu
Super User
Anonymous
try to add +1 in the end
Duration.Days([pcreatedon]-[createdon]) +1
- AnonymousNot applicable
This seems to work. I want grab the days and filter out weekend and holidays. I have a calendar table where I have a column indicating if a weekday is a weekend/holiday. Weekday = 1 else =0.
How would I go about this