Forum Discussion
Solved
DAYS function - How to include start and end date
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?
Goran1617 Well, that how the DAYS function works by design. If you want the extra day just add +1 to your formula.
2 Replies
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".
