Can a worksheet date itself?

Scout

Posts: n/a

Can a worksheet date itself?

Is it possible for Excel to compute the day of the week for a given month and
year?

I'd like to add this to an Excel timesheet in order to automatically number
the days of each week for any given month. The real crux, IMO, is
identifying the first day of the month.

See column A in:
http://www.servalt.com/timesheet2c.xlt

Thanks in advance, Excel gurus!

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Transferring date from multiple worksheets to a "totals" worksheet.	tonyDeBrasco	Excel Discussion (Misc queries)	3	July 22nd 05 05:43 PM
referencing another worksheet	chartasap	Excel Worksheet Functions	2	July 13th 05 01:58 PM
Despite formatting a column in Excel 2002 worksheet as Short Date.	Pete Whalley	Excel Discussion (Misc queries)	2	February 7th 05 06:17 PM
Weekly Transaction Processing	Ralph Howarth	Excel Worksheet Functions	4	January 19th 05 05:37 AM
Using formulas to determine date in one cell based on date in anot	Gary	Excel Worksheet Functions	2	November 22nd 04 08:11 AM

All times are GMT +1. The time now is 06:40 AM.

Menu

About Us