SOLVED

DAYS function - How to include start and end date

Copper Contributor

I cannot seem to find the correct addition to the "DAYS(end; date; start_date)"- function.

I'm only receiving the days in between, so one day is missing in the total count. 

 

Any suggestions?

2 Replies
best response confirmed by HansVogelaar (MVP)
Solution

@Goran1617 Well, that how the DAYS function works by design. If you want the extra day just add +1 to your formula.

Thank you! It works now. It was giving me a strange looking result earlier, but I realise that I had forgotten to format the field to "Number".
1 best response

Accepted Solutions
best response confirmed by HansVogelaar (MVP)
Solution

@Goran1617 Well, that how the DAYS function works by design. If you want the extra day just add +1 to your formula.

View solution in original post