PSX5Central

Non Gaming Discussions => Off-Topic => Topic started by: Richard on January 17, 2006, 11:37:25 AM

Title: EXCEL 2003: Calculate Weekdays in a given Date Range
Post by: Richard 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))

Title: EXCEL 2003: Calculate Weekdays in a given Date Range
Post by: CHIZZY 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.

Title: EXCEL 2003: Calculate Weekdays in a given Date Range
Post by: Richard 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.

Title: EXCEL 2003: Calculate Weekdays in a given Date Range
Post by: mjps21983 on January 17, 2006, 12:44:07 PM

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

Title: EXCEL 2003: Calculate Weekdays in a given Date Range
Post by: Richard 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))

Title: EXCEL 2003: Calculate Weekdays in a given Date Range
Post by: THX on January 17, 2006, 02:13:44 PM

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

Title: EXCEL 2003: Calculate Weekdays in a given Date Range
Post by: Cyrus 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

Title: EXCEL 2003: Calculate Weekdays in a given Date Range
Post by: Eiksirf on January 17, 2006, 03:57:04 PM

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

...

-Dan

Title: EXCEL 2003: Calculate Weekdays in a given Date Range
Post by: square_marker 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"

Title: EXCEL 2003: Calculate Weekdays in a given Date Range
Post by: CHIZZY on January 18, 2006, 04:09:46 AM

sorry, mom.

Title: EXCEL 2003: Calculate Weekdays in a given Date Range
Post by: videoholic 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.

Title: EXCEL 2003: Calculate Weekdays in a given Date Range
Post by: Cyrus 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