Forum Discussion
fixed date
Hello, I have this problem: I need when I write something in cell B1 then G1 gives me the date(date of writing). I've tried this formula in G1: =IF(B1<>"";NOW();"") but it doesn't work ...
Ahmad,
The NOW() function always returns the current date and is updated when you open the workbook, as you have found out. The only way to do as you wish would be to either manually type the date into the cell or use COPY and PASTE SPECIAL in the cell to overwrite the NOW() function. Finally you could write a macro to add the date.
Rich
The NOW() function always returns the current date and is updated when you open the workbook, as you have found out. The only way to do as you wish would be to either manually type the date into the cell or use COPY and PASTE SPECIAL in the cell to overwrite the NOW() function. Finally you could write a macro to add the date.
Rich
thanks!
I thought there could be a way to stop the "refresh" or other function to do the job , some functions related to " DATE "
thanks!
Ahmad
