How to subtract dates in SharePoint 2007 columns?
Posted on 2013-05-15
Dear EE experts,
We would like to ask on how to subtract dates in SharePoint 2007 columns? We would like to get the total number of Years/Months/Days that the staff worked in the company.
- Date Start
- current date
- Total years in work
If we subtract the 'Current date' column to 'date start' column, it will give us different date...
What we want to happen is something like:
= Current date - Date start
= May 15, 2013 - January 2, 2007
then it should give us 6yrs, 5months, & ...
thank you in advance & hope to hear soon...