New Contributor

# Date calculation

H everybody !

I need help on my excel....

I have an excel with two columns, on for the entry date and one for the exit day.

I use it to calculate the price when i kkeep dog.

When in want to do a function to calculate the time between this two dates, there is always a mistake.

for exemple i have a dog 3 days from the 21/07/2020 to the 23/07/2020,

=(21/07/2020 - 23/07/2020)*price = ___€

but between this two dates, it takes me 2 days instead of 3...

do you have a solution ?

I use excel 2019

thanks

3 Replies

# Re: Date calculation

You just need to add 1 after subtracting the dates.

e.g. if A2 has the Start Date and B2 has the End Date, you may try...

=(B2-A2+1)*Price

# Re: Date calculation

Hello @Gweno50 ,

The difference in date always gives the days between two dates in subject, hence you needs to add 1 to the difference

Please find below the possible solution

Sample excel sheet is also attached.

Hope this will of help to you.

Cheers.

@sunil_daware