Create Month Timetable on a worksheet different month each works

C

Courtney

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
 
R

Roger Govier

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, Format>Cells>Number>Custom> 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.
 
Top