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

B

BW

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculating pay dates 4
Arranging dates in a single column 5
Schedule Events 2
Month (MMM) from date (dd/mmm/yy) 1
Format Template Merged Date Fields dd/mm/yyyy to Words 1
Date Format 2
Spurious Formula Omits Adjacent Cells 2
Finding dates without attention to data formats 3

Top