days between

Good day, hopefully I can get some help as I am not an Excel avid user. I am trying to calculate the number of days between 2 dates if certain criteria is met. As seen in the pic, Column B contains Order Numbers, each order number has multiple rows as each process step has a different sequence...

Hi all. I need to calculate the number of days based on several variables and I just can't get them all in there. This would be based on a reference period, for example: Period 01/01/21 to 01/31/21 There could be several options that I need to cover in my formula, so 4 different dates are...

Hello All, I hope everyone is keeping healthy & happy! Just a quick question. I have a userform that contains four textboxes; 1x start date, 1x end date, 1x Alternate Day number & 1x result. A user enters a starting and ending date, eg "01/oct/2020" and an end date "04/jan/2021". In the...

Can the DAYS function be adapted to only count visible cells? What I am trying to do is to divide the number of days between 2 dates into the number of selections I have. This tell me how many selections per day I have. Here is the formula I have: =F5549/DAYS(A5524,A3) This works alright when...

Need help on what formula to use to calculate the tenure of an employee from hire date in one cell and have that cell tenure count change once I put the resignation date of the employee in another cell

Hi experts - I'm looking for a macro to calculate the number of work days since a date (when a document was signed). Below is columns F and G from the workbook. <tbody> Document signed date Workdays since 01-January-2018 15-February-2018 </tbody> Now, I know that this can be fairly...