Pasting a Date into cells that have data in only

[DharmeshChauhan]

Hi

I have posted my question on another forum and im unable to paste the link to this cross post

I dont want to break any rules, hence why i have posted first

Thanks

Dharmesh

http://www.mrexcel.com/board/threads...-only.1212207/

[AliGW]

Post the URL of the cross post with TWO spaces in it (in other words, in three sections). I will then fix it for you. Please ask your question.

[DharmeshChauhan]

Hi

it still wont let me post the URL i get the below error message

The following errors occurred with your submission
You are not allowed to post any kinds of links, images or videos until you post a few times.

Could I PM you the link

[AliGW]

No - I asked you to split it into three.

Try without the www bit.

You will have the same problem in a PM. Other people have managed to do this once instructed, so you can do it.

[DharmeshChauhan]

This is my Question

[B]Hi

I have a numbers of rows with dates, some of the cells are blank in these rows

My manager asked to to find the earliest date in each row (used formula =SMALL(A1:D7,1) this returned me the earliest date from the row

I need to paste this result (earliest date) into all the cells that have a date and avoid the blank cells for each row

Thanks

[AliGW]

I've added the link to your opening post.

There are instructions at the top of the page explaining how to attach your sample workbook.

A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.

[DharmeshChauhan]

hi

Thanks for posting the Link

I have updated the post now, and it show a mini work book and i have commented

[AliGW]

There is no workbook attached to any post in this thread.

[DharmeshChauhan]

Hi

Sorry I cant see where to Attach the workbook on this thread

[JeteMc]

The banner at the top of the page titled "HOW TO ATTACH YOUR SAMPLE WORKBOOK" has instructions on how to attach a workbook to your next post in the thread.
Let us know if you have any questions.