G
Guest
Hello All-
First of all, I wanted to say 'Thank You' to everyone who post replies on
this site. I cannot speak for everyone, but I always appreciate when someone
take the time and effort to reply. Thank You!
Now my question. I work in Human Resources and I need to run reports on an
employee's gross pay 26 weeks prior to an injury date.
As an example, if an employee was injured on 06/14/06, I would need to find
out what the date was 26 weeks prior to 06/14/06. Going to my calendar and
counting back 26 weeks, I can tell you the date would be 12/14/05. I would
like to be able to open up an excel workbook, type the date of injury
(06/14/06) into a cell, and have excel calculate the 26 week difference
(12/14/05). I think the DateDif function would be used, but do not know how
to set up the formula. Could someone please supply the correct formula for
me if possible? Thank You!
First of all, I wanted to say 'Thank You' to everyone who post replies on
this site. I cannot speak for everyone, but I always appreciate when someone
take the time and effort to reply. Thank You!
Now my question. I work in Human Resources and I need to run reports on an
employee's gross pay 26 weeks prior to an injury date.
As an example, if an employee was injured on 06/14/06, I would need to find
out what the date was 26 weeks prior to 06/14/06. Going to my calendar and
counting back 26 weeks, I can tell you the date would be 12/14/05. I would
like to be able to open up an excel workbook, type the date of injury
(06/14/06) into a cell, and have excel calculate the 26 week difference
(12/14/05). I think the DateDif function would be used, but do not know how
to set up the formula. Could someone please supply the correct formula for
me if possible? Thank You!