Date of Entry

[dominion]

Hi Guys

I have a very simple question here. In Column B I would like to input a description and in column C I would like the date/time I input an entry in column B to appear automatically (for the same row).

Is this possible?

Thank you in advance!

[Fotis1991]

Yes it is.

1)Using formula(creating a circular reference)

2)Using VBA code.

What is your option?

[dominion]

I don't know VBA but I shall go pick it up. meanwhile could you show me option (1)? Thanks!

[Fotis1991]

Yes here you are!

[imran91]

you can use this formula =IF(B1="","",NOW()) in cell c1. and then format cell to custom dd/mm/yyy hh:mm am/pm

[Fotis1991]

@ imran91.

Pls note that using your suggested formula, the date will change to tomorrow date, when Tomorrow will come.

[imran91]

hi fotis 1991. what do you mean that the date will change to tomorrow date? i already try it and work just fine.

[Fotis1991]

I mean that you have to wait unti tomorrow! Tomorrow in c1 the date will be 18/12/2012. Not 17/12/12 as it is today()-now().

[imran91]

ahh ok. thanks for correcting.

[john910]

imran,

What if you don't want the date to change but stay the same as when the entrty was made?

Thanks,
John

[Fotis1991]

"imran,

What if you don't want the date to change but stay the same as when the entrty was made?

Thanks,
John

Then do what i suggested in post#4

[dominion]

Yup Fotis is right, i wanted a time stamp instead of a changing date.

Thanks a lot for the answer!

Will mark this thread as solved!