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

 
New Topic

New Poll

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

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