Reoccuring Meeting

Bob:

I think I need to provide you with more information. I should have been clearer. Sorry.

I need this calculation to take place in one cell. I'll use an example:

I have a meeting on Thursday Nov 5 2009. I then have my next meeting on Thursday Nov 12 2009. On Wednesday Nov 4 2009, the cell should read "Thursday Nov 5 2009". When the "today's date" changes to Friday Nov 6 2009, the cell should read "Thursday Nov 12 2009".

Is this possible?

Thanks.

Yes, it is possible, something similar to this might do it:

=IF(WEEKDAY(NOW(),3)<4,NOW()+(7-WEEKDAY(NOW(),3)),NOW()+1+WEEKDAY(NOW(),3))

Note that it is too late at night, my brain has stopped working. You may
have to play with that to get it to work right.

Are you SURE you shouldn't be doing this in Entourage?

Cheers


On 15/10/09 12:44 PM, in article 59b7e52f.1.TakeThisOut@webcrossing.caR9absDaxw,
"Audiophile@officeformac.com" <Audiophile.TakeThisOut@officeformac.com> wrote:

> Bob:
>
> I think I need to provide you with more information. I should have been
> clearer. Sorry.
>
> I need this calculation to take place in one cell. I'll use an example:
>
> I have a meeting on Thursday Nov 5 2009. I then have my next meeting on
> Thursday Nov 12 2009. On Wednesday Nov 4 2009, the cell should read "Thursday
> Nov 5 2009". When the "today's date" changes to Friday Nov 6 2009, the cell
> should read "Thursday Nov 12 2009".
>
> Is this possible?
>
> Thanks.

This email is my business email -- Please do not email me about forum
matters unless you intend to pay!

--

John McGhie, Microsoft MVP (Word, Mac Word), Consultant Technical Writer,
McGhie Information Engineering Pty Ltd
Sydney, Australia. | Ph: +61 (0)4 1209 1410
+61 4 1209 1410, mailto:john@mcghie.name