Formula to display nearest following Thursday in mm/dd/yyyy format
in [Functions]
|
Prev: How do I calculate a weighted average and exclude the empthy cells
Next: bank transfer error numbers display from workbook to csv
From: BW on 27 May 2010 20:43 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 27 May 2010 21:07
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 |