ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Background and Calendar (https://www.excelbanter.com/excel-worksheet-functions/229563-background-calendar.html)

lbdas311

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.

Dennis Tucker

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.


TechGuy

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


All times are GMT +1. The time now is 07:23 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com