If formula showing date

Solved/Closed
simeonmein Posts 2 Registration date Wednesday October 9, 2013 Status Member Last seen October 9, 2013 - Oct 9, 2013 at 05:28 AM
simeonmein Posts 2 Registration date Wednesday October 9, 2013 Status Member Last seen October 9, 2013 - Oct 9, 2013 at 02:56 PM
Hi all, I created a spreadsheet that has a date in and a date out columns, the dormula I use on the date column is: =if(d2,TODAY(),""). Formula is in cell j2
PROBLEM IS IT CHANGES THE DATE EVERY DAY! I need a formula that will enter todays date and keep it untill the value in d2 changes(but it won't).

Any help will be greatly appriciated

2 replies

Mazzaropi Posts 1978 Registration date Monday August 16, 2010 Status Contributor Last seen November 18, 2022 146
Oct 9, 2013 at 02:52 PM
Simoneonmein, Good afternoon.

Using function TODAY() you obtain a dynamic date. Always.

There are only two ways to obtain a fixed date depending on other situation.
- You TYPE manually the date.

- You use VBA or MACRO to input the date at the desired cell.

I hope it helps.
0
simeonmein Posts 2 Registration date Wednesday October 9, 2013 Status Member Last seen October 9, 2013
Oct 9, 2013 at 02:56 PM
Thank you, but I managed to use a simple way. Where I give the textboxes commands to go, I gust simply added: ".offset(0, 8) = date" at the end and works every time.

Thanx
0