Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Grid? Calendar in excel
- Thread starter canajun
- Start date
If you search this forum for
Calendar Excel
You will find lots of examples. Look particularly at those with lots of stars.
That said your requirement looks straightforward.Your dates (1,2,3 etc) should be real dates but create a date format that displays only the day.
In your first column the date format would display only the Month.
A2=B2
B2=1April2006
C2=B2+1
Depends how sophisticated you want to be. For a one off that and the posts referred to above is probably enough to get you started.
Gavin
Calendar Excel
You will find lots of examples. Look particularly at those with lots of stars.
That said your requirement looks straightforward.Your dates (1,2,3 etc) should be real dates but create a date format that displays only the day.
In your first column the date format would display only the Month.
A2=B2
B2=1April2006
C2=B2+1
Depends how sophisticated you want to be. For a one off that and the posts referred to above is probably enough to get you started.
Gavin
- Status
Similar threads
- Locked
- Question