IF statement

[Deaddog]

Should be an easy one for you guys, I'm trying to produce a time/date stamp without using VB code, needs to be a simple formula.

I'm trying this "=IF(F6="","",(now))" but it returns "#NAME?"

Any suggestions?

Thank you

 

[AlanY]

should be

=IF(F6="","",now())

and format cell as time

 

[Deaddog]

that works, but I need the time to stay static (time stamp)

the time and date changes to current when I reopen sheet.

 

[Danmc]

try this:

sub do_time()
dim x as date
x = now()
putrangehere = "=if(f6 = "", "", x)"

 

[Deaddog]

I can't do it with code, I need it to be a formula.
Is that even possible?

 

[Joe4]

The problem is that a cell can either have a hard-coded values, or a formula. A formula that returns the current date/time is dynamic (always changing).
So you cannot do anything automatically without VBA.

However, you can use keyboard shortcuts and/or circular references to enter date/time stamps.
See here: https://trumpexcel.com/date-timestamp-excel/

 

[Danmc]

honestly don't know if you can do this with a formula, might have to ask one of the guru's.

 

[Joe4]

honestly don't know if you can do this with a formula, might have to ask one of the guru's.

See my reply above.

 

[Deaddog]

thanks for all the answers, I can do it with VBA, but when I put the sheet online it removes the VBA, that's why I'm trying to do it with a formula.

 

[Deaddog]

I think you are going to be out of luck then.
As I mentioned, it needs to be done either by VBA or manually. There is no automated formula solution.

Thank you