Problem I. 155. (March 2007)
I. 155. Zeno decides to make use of a spreadsheet, since he tends to forget about birthdays. The sheet issues a reminder one week before the event. Beginning with the second line, Zeno has already entered the names and birthdays into the first two columns of the sheet. Now he asks for our help to finish the sheet.
He would like to have the actual date in cell A1. The second cell of the same row should contain the number of days to the nearest birthday and the name(s) of the person/people having birthday then, provided that this event occurs within a week. If there are more people, their names should be separated by commas. If there is no birthday in the near future, that cell should be left empty.
The sheet (i155.xls, ...) is to be submitted.
Deadline expired on 16 April 2007.
Sorry, the solution is available only in Hungarian. Google translation
A feladat mintamegoldása: i155minta.xls