Ric F
Board Regular
- Joined
- Apr 15, 2011
- Messages
- 117
- Office Version
- 365
Good afternoon!
I'm trying to figure if there is a way to populate the date that someone enters a value in say column A with today's date, but then that date never changes when someone opens up the filetomorrow or 2 weeks from now to add to the list. so in otherwords - in D2 - IF(A2 >0,{then today's never changing date},"").
Can this be done?
Thanks in advance!!
Ric
I'm trying to figure if there is a way to populate the date that someone enters a value in say column A with today's date, but then that date never changes when someone opens up the filetomorrow or 2 weeks from now to add to the list. so in otherwords - in D2 - IF(A2 >0,{then today's never changing date},"").
Can this be done?
Thanks in advance!!
Ric