
New Member

January 12, 2023

Hello all,
I need some help.
I have an small excel with 5 rows and I need a formula that inserts a fix date.
The rows are:
Location-task-status-pending-completed
On the status row I have a drop-down menu with 3 options(new,pending,done)
What I exactly need is to convert this formula into a fix date:
=IF(cell="text", value_to_return, "")
So if in “status row” I choose “done option”, in the “completed row” it shows the date this option was chosen.
Where “value to return” is a fix date for the option chose on status and does not change unless you change on the drop-down menu.
I am attaching a screen shoot.
I thanks you in advace for you help.


Trusted Members

February 13, 2021

If I understand you correctly, you want to enter the date when you change your dropdown. So if I go in today and change to "new" the date in the "New" column will read today's date, am I correct? If my understanding is correct I don't believe it can be done without using VBA. There are a couple of issues, first I was thinking of using TODAY(), but if you do that the date will constantly change, if you want to keep the dates in there as you change your status; i.e. changed dropdown to "new" today and "pending" tomorrow and want "New" to continue showing today's date and add the new date tomorrow for the "pending" status, your date will no longer show in the "New" column because the status is no longer "new". I hope I'm making sense. If I am totally off in my understanding please let me know, otherwise good luck! 🙂
1 Guest(s)
