Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old October 7th 05, 02:06 AM
_Bigred
 
Posts: n/a
Default how to count weeks from date "X" then calculate

I want to create a field(s) in Excel 2003 that will allow me

to enter a hard (non-changing date) and have it calculate how many weeks
have eclipsed since that time and then multiply to 40 hrs per week to give a
total of work hours that have passed since the date

The Date desired to use is July 1st, 2005 and counting.....

TIA,
_Bigred




  #2   Report Post  
Old October 7th 05, 02:40 AM
Biff
 
Posts: n/a
Default

Hi!

Try this:

A1 = 7/1/2005

=(TODAY()-A1)/7*40

Biff

"_Bigred" wrote in message
...
I want to create a field(s) in Excel 2003 that will allow me

to enter a hard (non-changing date) and have it calculate how many weeks
have eclipsed since that time and then multiply to 40 hrs per week to give
a total of work hours that have passed since the date

The Date desired to use is July 1st, 2005 and counting.....

TIA,
_Bigred





  #3   Report Post  
Old October 7th 05, 02:42 AM
Ron Rosenfeld
 
Posts: n/a
Default

On Fri, 07 Oct 2005 01:06:27 GMT, "_Bigred" wrote:

I want to create a field(s) in Excel 2003 that will allow me

to enter a hard (non-changing date) and have it calculate how many weeks
have eclipsed since that time and then multiply to 40 hrs per week to give a
total of work hours that have passed since the date

The Date desired to use is July 1st, 2005 and counting.....

TIA,
_Bigred



With your date in A1, something like

=(TODAY()-A1)/7*40

Or if you want to count only workdays at 8 hrs/day, you could use the
NETWORKDAYS function.

=NETWORKDAYS(A1, TODAY(), holidays) * 8

See HELP for this function. It requires installation of the Analysis Tool Pak
and HELP will tell you how to do that.


--ron
  #4   Report Post  
Old October 7th 05, 02:51 AM
RagDyer
 
Posts: n/a
Default

With July 1, 2005 in A1,
Try this in a cell formatted to General or Number:

=DATEDIF(A1,TODAY(),"d")/7*40

The base formula returns days, so dividing by 7 will yield full and partial
weeks.

If you want to only work with full weeks, adjust it to this:

=INT(DATEDIF(A1,TODAY(),"d")/7)*40

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"_Bigred" wrote in message
...
I want to create a field(s) in Excel 2003 that will allow me

to enter a hard (non-changing date) and have it calculate how many weeks
have eclipsed since that time and then multiply to 40 hrs per week to give

a
total of work hours that have passed since the date

The Date desired to use is July 1st, 2005 and counting.....

TIA,
_Bigred




  #5   Report Post  
Old October 7th 05, 07:50 AM
Arvi Laanemets
 
Posts: n/a
Default

Doun't you have any state holdays there at all ?

P.e. I myself have additionally to think about 4 pre-holidays - there are 4
state holidays, for which when preceeding day is workday, it is 5 hours long
instead of 8 hours.


--
Arvi Laanemets
( My real mail address: arvil<attarkon.ee )



"_Bigred" wrote in message
...
I want to create a field(s) in Excel 2003 that will allow me

to enter a hard (non-changing date) and have it calculate how many weeks
have eclipsed since that time and then multiply to 40 hrs per week to give
a total of work hours that have passed since the date

The Date desired to use is July 1st, 2005 and counting.....

TIA,
_Bigred







  #6   Report Post  
Old October 18th 05, 07:02 AM
_Bigred
 
Posts: n/a
Default how to count weeks from date "X" then calculate

I used the DATEDIF formula below and it works fine. Is there a way I can
limit it's return.
Example: It will only calculate the number of hours until a certain date
(i.e from 7/1/05 thru 6/29/06)

??
TIA,
_Bigred



"RagDyer" wrote in message
...
With July 1, 2005 in A1,
Try this in a cell formatted to General or Number:

=DATEDIF(A1,TODAY(),"d")/7*40

The base formula returns days, so dividing by 7 will yield full and
partial
weeks.

If you want to only work with full weeks, adjust it to this:

=INT(DATEDIF(A1,TODAY(),"d")/7)*40

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"_Bigred" wrote in message
...
I want to create a field(s) in Excel 2003 that will allow me

to enter a hard (non-changing date) and have it calculate how many weeks
have eclipsed since that time and then multiply to 40 hrs per week to
give

a
total of work hours that have passed since the date

The Date desired to use is July 1st, 2005 and counting.....

TIA,
_Bigred






  #7   Report Post  
Old October 18th 05, 09:35 AM
Arvi Laanemets
 
Posts: n/a
Default how to count weeks from date "X" then calculate

Hi

=DATEDIF(A1,B1,"d")/7*40
(with end date in B1). Or
=DATEDIF(A1,DATE(2006,6,29),"d")/7*40
(with fixed end date)


Arvi Laanemets



"_Bigred" wrote in message
...
I used the DATEDIF formula below and it works fine. Is there a way I can
limit it's return.
Example: It will only calculate the number of hours until a certain date
(i.e from 7/1/05 thru 6/29/06)

??
TIA,
_Bigred



"RagDyer" wrote in message
...
With July 1, 2005 in A1,
Try this in a cell formatted to General or Number:

=DATEDIF(A1,TODAY(),"d")/7*40

The base formula returns days, so dividing by 7 will yield full and
partial
weeks.

If you want to only work with full weeks, adjust it to this:

=INT(DATEDIF(A1,TODAY(),"d")/7)*40

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"_Bigred" wrote in message
...
I want to create a field(s) in Excel 2003 that will allow me

to enter a hard (non-changing date) and have it calculate how many

weeks
have eclipsed since that time and then multiply to 40 hrs per week to
give

a
total of work hours that have passed since the date

The Date desired to use is July 1st, 2005 and counting.....

TIA,
_Bigred










Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
NETWORKDAYS - Multiple Date Selection Annabelle Excel Discussion (Misc queries) 3 October 4th 05 07:04 PM
How to calculate Date & Time differences robs Excel Worksheet Functions 2 October 4th 05 04:22 PM
Calculate weeks cover \Kevin Carroll via OfficeKB.com\ Excel Worksheet Functions 2 July 8th 05 01:00 AM
calculate anniversary of date after specified date slymeat Excel Worksheet Functions 3 July 5th 05 01:53 AM
Count the occurances of a month in a range of date fields Keith Brown Excel Worksheet Functions 8 March 14th 05 12:24 PM


All times are GMT +1. The time now is 11:43 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017