DateDif ?
 

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!
--
My idea of rebooting is kicking somebody in the butt twice.

DateDif ?
 

Hi

It's not that complicated. 1 is a day in excel. So a week is 7, and 26 weeks
is 7*26. Your date in A1, formula in B1:
=A1-(7*26)

HTH. Best wishes Harald

"nhvwchic" skrev i melding
...
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!
--
My idea of rebooting is kicking somebody in the butt twice.

DateDif ?
 

Thank you very much! It worked slick and is going to make running this
report a whole lot easier.

Alaina
--
My idea of rebooting is kicking somebody in the butt twice.


"Harald Staff" wrote:

Hi

It's not that complicated. 1 is a day in excel. So a week is 7, and 26 weeks
is 7*26. Your date in A1, formula in B1:
=A1-(7*26)

HTH. Best wishes Harald

"nhvwchic" skrev i melding
...
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!
--
My idea of rebooting is kicking somebody in the butt twice.

DateDif ?
 

Glad you liked it Alaina. Thank you for the feedback.

Best wishes Harald

"nhvwchic" skrev i melding
...
Thank you very much! It worked slick and is going to make running this
report a whole lot easier.

Alaina