corsasport.co.uk
 

Corsa Sport » Message Board » Off Day » Geek Day » Auto Calender In excel


New Topic

New Poll
  Subscribe | Add to Favourites

You are not logged in and may not post or reply to messages. Please log in or create a new account or mail us about fixing an existing one - register@corsasport.co.uk

There are also many more features available when you are logged in such as private messages, buddy list, location services, post search and more.


Author Auto Calender In excel
IvIarkgraham
Premium Member

Avatar

Registered: 27th Mar 04
Location: Ellesmere Port, Cheshire
User status: Offline
6th Nov 17 at 16:28   View Garage View User's Profile U2U Member Reply With Quote

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
22nd Nov 17 at 14:05   View User's Profile U2U Member Reply With Quote

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

Avatar

Registered: 27th Mar 04
Location: Ellesmere Port, Cheshire
User status: Offline
25th Nov 17 at 21:25   View Garage View User's Profile U2U Member Reply With Quote

gone a different route but cheers anyway

 
New Topic

New Poll

  Related Threads Author Forum Replies Views Last Post
is there a program that...... chris_uk Geek Day 6 1889
16th Jun 05 at 00:47
by Dan B
 
Excel Help AndyKent Geek Day 3 1450
6th Oct 07 at 10:22
by aPk
 
need an excel like programme (for free) Shane Geek Day 12 1767
13th May 08 at 14:55
by pow
 
excel auto changing my numbers!? Jas Geek Day 12 804
11th May 11 at 12:24
by sc0ott
 
Microsoft Excel strick206 Geek Day 10 1477
6th Jul 11 at 14:46
by Sam
 

Corsa Sport » Message Board » Off Day » Geek Day » Auto Calender In excel 29 database queries in 0.0112290 seconds