Author Topic: EXCEL 2003: Calculate Weekdays in a given Date Range (Read 878 times)

« **on:** January 17, 2006, 11:37:25 AM »

I want to create an Excel document where I can specify a date range ex. Monday 16, 2006 - Sunday 22, 2006 and have Excel return the dates in selected cells.

A good scenario would be a timesheet.

EXAMPLE:
--------------------------------------------------
Enter date range:
Monday 16, 2006 - Sunday 22, 2006

And then in the cells of my choice Excel would return the following:

Monday 16, January 2006

Tuesday 17, January 2006

Wednesday January 18, 2006

Thursday January 19, 2006

Friday January 20, 2006

Saturday January 21, 2006

Sunday January 22, 2006
--------------------------------------------------

I have tried EDIT | FILL | SERIES...

as well as

=TREND({"1/16/06";"1/22/06"}+0,{1;20},ROW(1:20))

CHIZZY · « **Reply #1 on:** January 17, 2006, 11:52:23 AM »

You cannot possibly expect help here with your work until you make some gay jokes or penis jokes. Or some gay penis jokes.

Fag.

« **Reply #2 on:** January 17, 2006, 12:18:51 PM »

It was an honest question in the appropriate forum. If you didn’t want to contribute a suggestion, you didn’t have to read it.

« **Reply #3 on:** January 17, 2006, 12:44:07 PM »

It\'s just Chizz, have you tried google?

« **Reply #4 on:** January 17, 2006, 01:09:53 PM »

I have been browsing Google, but nothing other than the suggestions that I posted above

I have tried EDIT | FILL | SERIES...

as well as

=TREND({"1/16/06";"1/22/06"}+0,{1;20},ROW(1:20))

« **Reply #5 on:** January 17, 2006, 02:13:44 PM »

http://www.psx2central.com/forums/showthread.php?threadid=37494

« **Reply #6 on:** January 17, 2006, 02:28:18 PM »

if you really want to know the answer to this I will get it for you I have a girl staffed that is the goddess of excel

« **Reply #7 on:** January 17, 2006, 03:57:04 PM »

I\'m sure he doesn\'t really want to know.

...

-Dan

« **Reply #8 on:** January 17, 2006, 06:01:37 PM »

there is a date function somewhere.

if you cant find that just use microsoft help... type in the question tab something like... "how to do consecutive dates"

CHIZZY · « **Reply #9 on:** January 18, 2006, 04:09:46 AM »

sorry, mom.

videoholic · « **Reply #10 on:** January 18, 2006, 06:42:00 AM »

It\'s really very simple. You just tell it the cells are dates, enter the first date and use formulas for the rest.

I can get Logan to make a template for you.

« **Reply #11 on:** January 18, 2006, 07:10:46 AM »

Well she came up with the same thing as Vid was basically saying be sure to change the file ext to .xls

Hello

Author Topic: EXCEL 2003: Calculate Weekdays in a given Date Range (Read 878 times)