| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Converting Date to Work Week...
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Work Week calender | Excel Discussion (Misc queries) | |||
| How can I convert a date format to an ISO week format (in EXCEL)? | Excel Discussion (Misc queries) | |||
| how do i add numbers corresponding to same date on different work. | Excel Worksheet Functions | |||
| Converting a date in Excel 2002 to a Year/Quarter format | Excel Worksheet Functions | |||
| How can I create formula that turns a date into the week # in | Excel Discussion (Misc queries) | |||
Threaded Mode
