I need a date!

[imported_unknown]

I am writing a library 'program' in excel, and i've hit a snag. when people sign out books, the date is printed. the problem is this date keeps on changing everytime you open up the spreadsheet. is there a way to put a 'now' function, that doesn't change the date each time you load it?

-Zak


p.s. im having trouble with the followting things too:

Avaliable on/off (relates to other fields)
Overdue yes/no (relates to return date)
and color change depending if certain criteria are met.

!!!

p.p.s. Yes, i am a noob at this.

 

[imported_unknown]

if today's date is greater than the return date, overdue would turn red.

if the book is avaliable for removal, avaliable is green.

 

[Brian from Maui]

The first part todays date greater than the return date.

A1 houses return date
B1 houses due date or todays date

click on B1 or any cell where you want the cell to turn color, Go to Format/Conditional Formatting, enter in formula is =B1-A1>=1, select pattern color click OK OK

The second part, how do you know the book is available?

 

[imported_unknown]

The library is really small. about 60 books. This won't often be used, and is difficult to access. It's easy to find which books are out, because all the borrower information is there. if its avaliable, no one has it. so if 'last name', 'first name', and/or 'borrower's telephone number' is occupied, someone has taken it out.

This would be alot easier if i could post the spreadsheet up, and people could see what i mean...

!!!
-Zak

 

[Brian from Maui]

Zak,

Download Colo's utility which is at the bottom of the page

In the meantime you could use something like

=isblank(a1) in conditional formatting. If the cell is blank show green, if not no color
This message was edited by Brian from Maui on 2002-10-03 23:56