Dating Problem! [Solved/Closed]

Report
Posts
6
Registration date
Tuesday October 15, 2013
Status
Member
Last seen
November 30, 2013
-
Posts
6
Registration date
Tuesday October 15, 2013
Status
Member
Last seen
November 30, 2013
-
Hi

Can you help?

I need a cell to only input if a lead cell is blank but if the lead cell has a date format i.e 24/11/13 then to input that same data?

Thanks

Tim

4 replies


Good Evening.

You had me until the statement of "input the same data".

Please clarifiy.
Posts
6
Registration date
Tuesday October 15, 2013
Status
Member
Last seen
November 30, 2013

Hi, sorry....

So cell a1 = blank. but a date will be put in when required.

so cell a1 sheet 2 is blank until the date is put in on sheet 1. then sheet 2 cell a1 = the date sheet 1 cell a1 states.

Thanks

Tim

Tim,

On sheet 2 cell a1: =IF(Sheet1!A1<>"",TEXT(Sheet1!A1,"MM/DD/YYYY"),"")



I hope this helps!
Posts
6
Registration date
Tuesday October 15, 2013
Status
Member
Last seen
November 30, 2013

Glad my jumble made sense. Thank-you very much it now works, tried so many commands myself!!

This has made my day!

Kind Regards
Tim
Blocked Profile
You are most welcome. I only hope I didn't do your homework for you.

//ark
Posts
6
Registration date
Tuesday October 15, 2013
Status
Member
Last seen
November 30, 2013

Most certainly not! home project only!

Thanks again
Tim