Custom Column Duration.Days (include first day)

[AA622]

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??

[ryan_mayu · Accepted solution]

@AA622 

try to add +1 in the end

Duration.Days([pcreatedon]-[createdon]) +1

[AA622]

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