LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default Equipment checkout calendar

I'm trying to set up a spreadsheet that tracks equipment being checked out,
and how much is left on a given day. I was planning to do a sheet with a
calendar - months across the top, dates 1-31 down the side. On the second
sheet, I have a info about who is checking out what on what date. I thought
I could reference the date on this list, and have it show up in the proper
cell on the calendar page. The person in charge of the equipment would just
enter the info about when stuff is being checked out, and then could look at
the calendar to see which dates still have equipment available. I don't know
how to do this - use julian dates? I have barely begun this project, so if
anyone knows of a better layout idea, I"m open to that, too.

Thanks,
joAnne
 
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
looking for equipment maintainance log highgear18 Excel Discussion (Misc queries) 1 November 24th 06 06:02 PM
How do I use a template to keep records for equipment? spartanfans13 Excel Worksheet Functions 0 June 27th 06 01:56 AM
Equipment Losses for American occupier qazwsxedcrfv Excel Discussion (Misc queries) 0 May 13th 06 12:13 PM
Please I need a good Equipment Inventory template Uche Excel Discussion (Misc queries) 0 December 5th 05 06:49 PM
How do I set up a equipment replacement reserve schedule Hank Excel Worksheet Functions 0 March 30th 05 07:19 PM


All times are GMT +1. The time now is 03:44 AM.

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

About Us

"It's about Microsoft Excel"