Auto fill date/time

Hi guys,

could someone here can help me regarding the date/time function.

I have spreadsheet that i want automatic fill-out the column A when Column B is not empty. when i enter name in column B, column A will fill automatic with Dates and Time Today. i have this formula =IF(F3<>"",NOW(),"") works but everytime i open the spreadsheet on the next day all the dates were changed in todays date.

i want to come up as per example below.

i.e
Column A Column B
Date Started Name
07/28/2010 11:09AM Albert
07/29/2010 7:10PM Lexi

Hi

I have attached the spreadsheet i need column "Issue date/time to fill out automatically when column requested by is not empty.

as i said i'm using this formula =IF(F3<>"",NOW(),"") to auto fill the date/time automatic.

is there any other way of doing this?

sorry here's the attachment

Here's a timestamp that only changes when you change the cell value.
It doesn't change when you save or open or make a change anywhere else on the sheet or force a recalculate and you
don't have to clear the data cell first just select the cell start typing and it's all done with formulas and No macros.
Just A timestamp formula and 2 helper formulas (which you could hide).

Please Login or Register  to view this content.

Data backup formula in B2

Please Login or Register  to view this content.

Timestamp Backup formula in C2

Please Login or Register  to view this content.

Timestamp formula in D2

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Hi DonkeyOte - Forum Guru

what will be the vba code for this?

the =IF(F2<>"",IF(D2,D2,NOW()),0) is working, but i want it if request by column "same row" is not empty will auto fill the date/time stamp. i.e column request by row 3 is not empty so therefore column issue date/time will auto fill as well.


thanks.

thanks a lot to all of u guys.

i will try those options.

im happy and thanks also to excel forum

do i need to put the formula first then copy the vba codes to view code, am i right?

actually roy im looking for any options. i want to have daTE/timestamp in column d were column f is not empty on the same row.

hi guys,

help me on this.. please see attached spreadsheet. i want column E to have date/time stamp everytime column D has value.

so please help me.