Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Worksheet Functions / August 2006

Tip: Looking for answers? Try searching our database.

DateDif ?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
nhvwchic - 23 Aug 2006 21:40 GMT
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!
Signature

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

Harald Staff - 23 Aug 2006 21:47 GMT
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

> Hello All-
>
[quoted text clipped - 13 lines]
> to set up the formula.  Could someone please supply the correct formula for
> me if possible?  Thank You!
nhvwchic - 24 Aug 2006 14:13 GMT
Thank you very much!  It worked slick and is going to make running this
report a whole lot easier.

Alaina
Signature

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

> Hi
>
[quoted text clipped - 28 lines]
> for
> > me if possible?  Thank You!
Harald Staff - 24 Aug 2006 20:40 GMT
Glad you liked it Alaina. Thank you for the feedback.

Best wishes Harald

> Thank you very much!  It worked slick and is going to make running this
> report a whole lot easier.
>
> Alaina
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.