|
IvIarkgraham
|
posted on 25th Nov 17 at 21:25 |
gone a different route but cheers anyway
|
Neo
|
posted on 22nd Nov 17 at 14:05 |
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
|
posted on 6th Nov 17 at 16:28 |
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
|