subtract dates

My formula is : =DATEDIF(O2,AL$1,"y")&" years, "&DATEDIF(O2,AL$1,"ym")&" months, "&O2-DATE(YEAR(O2),MONTH(O2),1)&" days" Where O2 is the hire date and AL$1 is today() The formula works, kinda. It isn't doing the math correctly. I have a person who started exactly a year ago and it is 2...

Hi all. I hope you can help. I have inherited an excel sheet with a formula that I don't fully understand. Essentially I believe the formula is looking to determine the amount of time a task from creation date and time (Cell U2) took to complete from (Cell V2) both in hours and minutes. This is...

<tbody> 9/1/16 9/2/16 9/3/16 9/4/16 9/5/16 9/6/16 9/7/16 9/8/16 9/9/16 9/10/16 9/11/16 9/12/16 9/13/16 9/14/16 Item 1 1 1 1 1 1 Item 2 1 1 Item 3 1 1 1 1 1 1 </tbody> Hello, I was trying to figure out the best way to find the median/average...

=(YEAR(B4)-YEAR(B3))*12+MONTH(B4)-MONTH(B3) B3--31/11/2013 <tbody> B4--31/03/2014 format dd/mm/yyyy I continually get a return of #VALUE. Please help, Tom </tbody>

Hi, How can I subtract the below rows using the excel formulas to get the correct answers. 201601081026 201601081107 --- Producing wrong answer as 81 201601081040 201601081128 --- Producing wrong answer as 88 Please help me on this. Thanks Gobi

Hi There, I need to calculate the difference between two dates (in days) using VBA. I want the date to be put into the active cell and the start date and end date are referenced from that active cell. I think that my variables are not declared correctly or I need to convert the...

Hi all, Apologies for the layout as code tags are not working. I am populating sheets from a userform with work dates for different tasks for different employees and are trying to sum the data for display in the user form, days worked for year etc. No problem with this, just gotta get the data...