Forum Discussion

Goran1617's avatar
Goran1617
Copper Contributor
Jan 23, 2024
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?

2 Replies

  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor

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

    • Goran1617's avatar
      Goran1617
      Copper Contributor
      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".

Resources