Formula to display nearest following Thursday in mm/dd/yyyy format
 

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

Formula to display nearest following Thursday in mm/dd/yyyy format
 

Try this...

=A1+8-WEEKDAY(A1+3)

Format as Date

--
Biff
Microsoft Excel MVP


"BW" wrote in message
...
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