Jul 20 2021 04:34 PM - edited Jul 21 2021 04:56 PM
Hello,
I'm looking for some help with one formula on the Excel database I'm working on (column Q).
It is about calculating the delay (in # days) between two dates. The problem with making this difference is that only one of them is fixed and the other varies (depending on the date). I
n the attached Excel I had to do it case by case (row by row) for column Q, but I'm looking for a formula to automate it.
Thank you in advance for your help and advice!
John
PS: I also had doubts about my column C and D formulas but they seem to work. Feel free to give me your opinion on them. Thank you!
Aug 07 2021 03:42 PM - edited Aug 07 2021 03:42 PM
click the link in your sample workbook or go tohttps://exceljet.net/formula/get-days-months-and-years-between-dates#:~:text=To%20calculate%20and%20...
cheers
Aug 08 2021 03:36 AM