From: BW on
Hello,

I have been reading and trying different suggestions here to no avail. What
I need is a formula to calculate the nearest following thursday, and display
it in mm/dd/yyyy format.

To be clear, I have a column of varying dates. I need a formula to return
the next thursday for each of those dates.

To illustrate, say I have 05/22/2010, 05/23/201, 05/24/2010, & 05/26/2010 in
cells A1 through A4. In cells B1 through B4, I would like to see 05/27/2010,
05/27/2010, 05/27/2010, & 05/27/2010 representing the following thursday.

Thank you for your help!

BW
From: T. Valko on
Try this...

=A1+8-WEEKDAY(A1+3)

Format as Date

--
Biff
Microsoft Excel MVP


"BW" <BW(a)discussions.microsoft.com> wrote in message
news:4DBFB97E-E824-4D94-A762-B1648E7944A3(a)microsoft.com...
> Hello,
>
> I have been reading and trying different suggestions here to no avail.
> What
> I need is a formula to calculate the nearest following thursday, and
> display
> it in mm/dd/yyyy format.
>
> To be clear, I have a column of varying dates. I need a formula to return
> the next thursday for each of those dates.
>
> To illustrate, say I have 05/22/2010, 05/23/201, 05/24/2010, & 05/26/2010
> in
> cells A1 through A4. In cells B1 through B4, I would like to see
> 05/27/2010,
> 05/27/2010, 05/27/2010, & 05/27/2010 representing the following thursday.
>
> Thank you for your help!
>
> BW