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
|