IvIarkgraham
Premium Member
Registered: 27th Mar 04
Location: Ellesmere Port, Cheshire
User status: Offline
|
Is there a way for excel to add the date to the correct day in excel
I need a sheet that shows each day in the month but need the date next to the day too.
Need one every month so i'd rather spend time making a spreadsheet to save time at the start of every month.
Monday (Date) Tuesday (Date) Wednesday (Date) Thursday (Date) Friday (Date) Saturday (Date) Sunday (Date)
Monday (Date) Tuesday (Date) Wednesday (Date) Thursday (Date) Friday (Date) Saturday (Date) Sunday (Date)
Monday (Date) Tuesday (Date) Wednesday (Date) Thursday (Date) Friday (Date) Saturday (Date) Sunday (Date)
Monday (Date) Tuesday (Date) Wednesday (Date) Thursday (Date) Friday (Date) Saturday (Date) Sunday (Date)
Monday (Date) Tuesday (Date) Wednesday (Date) Thursday (Date) Friday (Date) Saturday (Date) Sunday (Date)
Spread sheet will look like that but can I get it to automatically enter the date in the correct box?
For December it will look like this....
Monday (N/A) Tuesday (N/A) Wednesday (N/A) Thursday (N/A) Friday (1/12/17) Saturday (2/12/17) Sunday (3/12/17)
Monday (4/12/17) Tuesday (5/12/17) Wednesday (6/12/17) Thursday (7/12/17) Friday (8/12/17) Saturday (9/12/17) Sunday (10/12/17)
Monday (11/12/17) Tuesday (12/12/17) Wednesday (13/12/17) Thursday (14/12/17) Friday (15/12/17) Saturday (16/12/17) Sunday (17/12/17)
Monday (18/12/17) Tuesday (19/12/17) Wednesday (20/12/17) Thursday (21/12/17) Friday (22/12/17) Saturday (23/12/17) Sunday (24/12/17)
Monday (25/12/17) Tuesday (26/12/17) Wednesday (27/12/17) Thursday (28/12/17) Friday (29/12/17) Saturday (30/12/17) Sunday (31/12/17)
Ideally I'd like to have a drop down box where you pick the month and the year and it inserts the info for you?
Can it be done? Thanks
|
Neo
Member
Registered: 20th Feb 07
Location: Essex
User status: Offline
|
You've probably sorted this, but in Excel if you search for default templates, one is named "Any year one-month calendar" and does exactly what you want.
|
IvIarkgraham
Premium Member
Registered: 27th Mar 04
Location: Ellesmere Port, Cheshire
User status: Offline
|
gone a different route but cheers anyway
|