Dating Problem!

Solved/Closed
rbmastertitan
Posts
6
Registration date
Tuesday October 15, 2013
Status
Member
Last seen
November 30, 2013
- Nov 7, 2013 at 10:38 AM
rbmastertitan
Posts
6
Registration date
Tuesday October 15, 2013
Status
Member
Last seen
November 30, 2013
- Nov 8, 2013 at 12:15 PM
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

Blocked Profile
Nov 7, 2013 at 05:19 PM
Good Evening.

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

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

Nov 8, 2013 at 09:57 AM
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
0
Blocked Profile
Nov 8, 2013 at 10:04 AM
Tim,

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



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

Nov 8, 2013 at 10:23 AM
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
0
Blocked Profile
Nov 8, 2013 at 11:35 AM
You are most welcome. I only hope I didn't do your homework for you.

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

Nov 8, 2013 at 12:15 PM
Most certainly not! home project only!

Thanks again
Tim
0