Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Background and Calendar

I am trying to create a background for a worksheet in which a calendar with
dates can be viewed while still being able to enter formulas into cells. I
would like to use Excel to record tips, hours, and paychecks from my job as a
waiter on a daily basis and use the records for calculate averages to help me
decide which days and shifts to work.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 140
Default Background and Calendar

As far as the background and calendar are concerned, I can not help you.

However, for the rest I can.

You are trying to optimize your money situation I see. This is a great project. This can be done in two ways.

1. No VBA coding or forms, use only worksheet functions with some manual operations(besides data entry).
2. Use VBA coding and forms to reduce the work to just data entry.

Both will work fine and the results can charted too.

VBA coding and forms is what I do for work. See the lin below.

http://phoenix.craigslist.org/wvl/cps/1144665428.html

Dennis

"lbdas311" wrote in message ...
I am trying to create a background for a worksheet in which a calendar with
dates can be viewed while still being able to enter formulas into cells. I
would like to use Excel to record tips, hours, and paychecks from my job as a
waiter on a daily basis and use the records for calculate averages to help me
decide which days and shifts to work.

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 16
Default Background and Calendar

Sounds like you should start with a simple Calendar in native Excel
spreadsheet format...
See the Free calendars available here... http://www.wincalendar.com/excel-calendar-template.htm
...you can add formulas & data to the Calendar day cells like any other
spreadsheet.
Enjoy
Mike
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Convert date from Gregorian Calendar to Hijri Calendar H.Alkhodary Excel Discussion (Misc queries) 1 February 21st 09 10:11 AM
find free sharware to include calendar pop or use calendar in cell ednc Excel Discussion (Misc queries) 2 April 14th 08 05:05 PM
how do i export excel calendar info to outlook calendar? Maggie Excel Discussion (Misc queries) 1 December 31st 07 10:27 PM
excel calendar - list of names displayed on calendar Brian'88 Excel Worksheet Functions 3 November 17th 06 10:31 PM
import calendar items from excel into outlook calendar jsewaiseh Excel Discussion (Misc queries) 0 September 2nd 05 03:53 PM


All times are GMT +1. The time now is 05:10 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"