Recognising dates for formula output

Hello.

Hopefully someone can be of assistance!

I have a workbook with three worksheets - 1st is an event register, 2nd is a calender (manually done, with no formulas due to format problems I couldn't solve), 3rd is a summary.

I am trying to work out the following;
The first column of the 1st sheet (event register) requires a date.
The second column requires an 'event', from a drop box or list (of seven possibilities). These are working fine.

Is there a formula I can use theat when a user enters a date, say 1 Jan 08 (or the format is "Thursday, 1 January 2008") AND a certain event, say "CALL" that this will automatically populate the next worksheet (calender) on that corresponding date (1 Jan 08)?????

There are seven possibilities for each date (eight including "blank" or ""), which I am sure I will be able to extend to each day of the calender once I work this formula out.

I have already formulated the second worksheet (calender) to count the freqency of events into the third worksheet (summary). Hopefully these wont effect the formula I am looking for.

Thanks in advance!

If the description of my problem isn't clear, please let me know!

RoyUK,

To be honest, I didn't actually understand what cross posting was. I didn't think this (posting the same question on a number of forums) was it - I just thought I would get better 'coverage' for a possible answer.

I searched a number of forums for the answer before I posted and couldn't find any common posts - or the solution to the problem.

Thanks for posting the hyperlinks to the other forums (ozgrid has been removed by the administrator for the same reason). I'll consider my hand smacked.

New users - don't cross post! And read the Forum Rules....

Pity I still don't have any idea how to solve my problem though (free or otherwise)...