Jul 19 2020 09:06 AM
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
Jul 19 2020 09:23 AM
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
Jul 19 2020 09:32 AM
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.
Jul 19 2020 09:57 AM
thanks for your answer.
add 1 to the result that what i already do but i was excpeting a better solution !
thanks