LinkBack URL
About LinkBacks
use DATEDIF(startdate,enddate,"Y")
datedif isnt like other normal formulas, excel wont help you try fill in the arguments
here is some reading on it
https://exceljet.net/excel-functions...tedif-function
use DATEDIF(startdate,enddate,"Y")
datedif isnt like other normal formulas, excel wont help you try fill in the arguments
here is some reading on it
https://exceljet.net/excel-functions...tedif-function
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Thanks for replying
I don't seem to have that formula when I press =? I only have DATE and DATEVALUE?
I have attached an example of what I have done so far. What I am trying to do is summarise the data before putting it into a table but as you can see I'm having a bit of trouble.
When an employee has worked less than a year its not sure what range to put it in. How can I get round this? I think I may need to put some dates in months?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks