Date calculation

Copper Contributor

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

@Gweno50 

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

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

sunil_daware_0-1595176244065.png

Sample excel sheet is also attached.

 

Hope this will of help to you.

 

Cheers.

 

@sunil_daware

 

thanks for your answer.

 

add 1 to the result that what i already do but i was excpeting a better solution ! 

 

thanks