PC Review


Reply
Thread Tools Rate Thread

Calendar Spreadsheet: Column 1 = Date, Column 2 Time of Day, Column 3 memo text field

 
 
JDJ
Guest
Posts: n/a
 
      24th May 2007
I am an excel novice. Looking for a template or instructions on how to
create a Calendar Spread Sheet with a single line for each day.

I.E. Left Hand Column Would be a date Column

Friday June 1st, 2007
Saturday June 2nd, 2007

or to make it more simple

Friday 06/01/07
Saturday 06/02/07
.... and so on (want to start with 2006)

2nd Column should be time of day

Want to be able to manually insert a duplicate a line, e.g. more than
one event on a given day.

Like to know how to create additional columns that are true false
and/or time of day fields.

Also want a final column that is a variable length text field for
comments.

Thanks for your help.
--

"J. J."
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
COUNTIF: 2 criteria: Date Range Column & Text Column =?Utf-8?B?TUFD?= Microsoft Excel Worksheet Functions 14 16th Sep 2008 04:39 PM
separate datetime value to date column, time column Mitchell_Collen via AccessMonster.com Microsoft Access ADP SQL Server 4 22nd Mar 2008 12:03 AM
A formula or macro that will place the date in an adjacent column Bany time something is typed in column A Mike C Microsoft Excel Programming 4 27th Feb 2008 01:57 AM
Referencing date column A & time column B to get info from column TVGuy29 Microsoft Excel Misc 1 24th Jan 2008 09:50 PM
combine date one column, with time another column into third? =?Utf-8?B?cHNhbHllcnM=?= Microsoft Excel Worksheet Functions 1 23rd Aug 2005 07:34 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 03:51 PM.