If formula showing date [Solved/Closed]

Report
Posts
2
Registration date
Wednesday October 9, 2013
Status
Member
Last seen
October 9, 2013
-
Posts
2
Registration date
Wednesday October 9, 2013
Status
Member
Last seen
October 9, 2013
-
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

Posts
1837
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
October 17, 2020
136
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.
Posts
2
Registration date
Wednesday October 9, 2013
Status
Member
Last seen
October 9, 2013

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