Can a worksheet date itself?

[Guest]

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!

 

[Chip Pearson]

Scout,

You can return the weekday as a number between 1 (Sunday) and 7
(Saturday) with the formula

=WEEKDAY(A1)

To get the weekday name, use a formula like =FORMAT(A1,"dddd")

To get the first day of the month, use

=DATE(YEAR(A1),MONTH(A1),1)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com