Currently I am manually adding the day and dates to the timesheeta.I am
seeking a way of opening a worksheet that will automatically show the days
and dates of the month

Hi Courtney

Assuming you want the days going down the sheet
In Cell A1 enter the first date you require
In cell A2
=A1+1 and copy down to cell A28
In cell A29 enter
=IF(MONTH($A$1+ROW(28:28))MONTH($A$1),"",$A$1+ROW (28:28))
and copy down through cells A30:A31
In cell B1 enter
=A1
and copy down through cells B2:B31

Mark column A, FormatCellsNumberCustom dddd
Format column B with whatever is your preferred date format.

You can use the same formula down the whole of column A if required, but
the checks are not necessary other than for days 29 through 31.

--
Regards

Roger Govier


"Courtney" wrote in message
...
Currently I am manually adding the day and dates to the timesheeta.I
am
seeking a way of opening a worksheet that will automatically show the
days
and dates of the month