Not sure if I can describe this...
I have a list of song titles that we use in our church. I presently have
them in an Impress spreadsheet like this:
|date of last use|title|
This way I can keep track of when the song was last used and not use it
too often.
However, some songs should be used more frequently than others (think
1-5, 1=heavy use, 5=light use).
|date of last use|title|use number|
I would like to program the spreadsheet so that it tells me, based on
the current date, date of last use, and use number, which songs are
available and which ones have been used recently.
So the calculation needs to do something like this:
A. Get today's date.
B. Get date of last use.
C. "Subtract" B from A.
D. Determine date of next allowable use based on B and "use number".
E. Compare D with C to determine if song is available or not.
I _think_ I can figure out how to do all of the above. However,
F. Apply red background to date of last use cell if the song is not
available.
|date of last use|title|use number|
^^^^^red background
G. Apply white background to date of last use cell if the song is available.
|date of last use|title|use number|
^^^^^white background
Can this be done in a formula? I know it can with a macro, but I have
little experience with them. Can a formula call a macro? Can this be
done at all?
All help is deeply appreciated.
Irv
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
