vinaygovekar
New Member
- Joined
- Jan 2, 2017
- Messages
- 1
I have data in below format in excel file. I required todays date in "Date" column once I put details in "Database" field.
For this I can put formula as "=TODAY()" but I want once this date come in "Date" folder It should not change.
E.g. on 1st Jan 2017 I put detail on "Database" column then in "Date" column date should come as 1-Dec-2017. And this date should not change further.
If you have any other formula please suggest.
<tbody>
</tbody>
For this I can put formula as "=TODAY()" but I want once this date come in "Date" folder It should not change.
E.g. on 1st Jan 2017 I put detail on "Database" column then in "Date" column date should come as 1-Dec-2017. And this date should not change further.
If you have any other formula please suggest.
Date | Database |
<tbody>
</tbody>