Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Convert date from Gregorian Calendar to Hijri Calendar | Excel Discussion (Misc queries) | |||
find free sharware to include calendar pop or use calendar in cell | Excel Discussion (Misc queries) | |||
how do i export excel calendar info to outlook calendar? | Excel Discussion (Misc queries) | |||
excel calendar - list of names displayed on calendar | Excel Worksheet Functions | |||
import calendar items from excel into outlook calendar | Excel Discussion (Misc queries) |