Create Month Timetable on a worksheet different month each works
 

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

Create Month Timetable on a worksheet different month each works
 

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