Menu
  1. Accueil
  2. Tech Forum
  3. Office Software
  4. Excel

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
See more

4 replies

Answer 1 / 4

Good Evening.

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

Please clarifiy.
Answer 2 / 4
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
Answer 3 / 4

Tim,

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



I hope this helps!
Answer 4 / 4
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
Report
Blocked Profile
You are most welcome. I only hope I didn't do your homework for you.

//ark
Report
Posts
6
Registration date
Tuesday October 15, 2013
Status
Member
Last seen
November 30, 2013
Most certainly not! home project only!

Thanks again
Tim
Ask a question