Return cell value of next available column

[juriemagic]

Hi,

I have a set of data ranging over 3 columns, going down to 100. The header of these 3 columns is a date, but the date itself is in the middle cell. So, B1 is a date, A2, B2 and C2 are data, going down to 100. I need a formula on sheet 2, which will tell me which date is the next available date. I do appreciate your time spend on this, Thank you..

[sktneer]

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[juriemagic]

thanx for helping me..please see attached...

[samba_ravi]

i can't understand what you are exactly looking for

[boopathiraja]

Hi, try this

Please Login or Register  to view this content.

[juriemagic]

You nailed it!!..thank you once again..

[boopathiraja]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.