On Thu, 2005-09-08 at 10:12 -0500, Irv Cobb wrote: > 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. >
Spreadsheets are nice but what you describe is really a database application. May I suggest that you investigate using a database. Doing so would make queries such as yours a snap. -- PLEASE KEEP MESSAGES ON THE LIST. OpenOffice.org Documentation Co-Lead http://documentation.openoffice.org/ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
