Date counting

Copper Contributor

Hi. So I'm making a chart which counts days of how long have i been to certain place. My problem is that when I write an arrival date, let's say for example 3.3.2023 and then date of departure, 4.3.2023, it gives me 1 day as an answer, but i need it to be 2 days. I need it to count all days I've been here, not just whole days. Please help, I don't know what to do anymore...excel chart.png

1 Reply

@Anna1415 Well, that formula counts only whole days by default. Just write +1 at the end of the formula to get the number you want.