Reoccuring Meeting

[Audiophile]

Version: 2008
Operating System: Mac OS X 10.4 (Tiger)
Processor: Power PC

I have a meeting that occurs every Thursday. What formula would I put into a cell that would automatically give me the date of the next meeting?

Thanks!

 

[CyberTaz]

One option: Enter the first date in a cell such as A10, then in an adjacent
cell enter the formula =A10+7 & copy using the fill handle for as many weeks
as necessary.

HTH |:>)
Bob Jones
[MVP] Office:Mac

 

[Audiophile]

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.

 

[John McGhie]

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

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:[email protected]