Hello,
I'm trying to convert a colum of entry dates to work weeks. I have a
helper row for month and year but I do not know if there is a quick way
(or a built in formula in excel) to determine the "work week" (within a
month).
For example:
ENTRY DATE: Month: Work Week:
8/26/05 August 4
8/19/05 August 3
etc.
Is there a formula that I can drag down this list of about 1,800 rows
with all different months?
Thanks,
PZan
--
PokerZan
------------------------------------------------------------------------
PokerZan's Profile:
http://www.excelforum.com/member.php...o&userid=23480
View this thread:
http://www.excelforum.com/showthread...hreadid=400134