Adding a date to a cell if a % value is added to the adjacent cell

[Dave_R1640]

I'm working on a scope doc to update when tasks have been started or completed. I want to add a date when the task has started / completed in say cell "H5" when I input a percentage into "G5". I want it to be todays date that is added to H5.  

How can this be done?

[#2]

@Dave_R1640 

If you need to fix added date that's with VBA programming/ Perhaps someone could help with this, but better if you clarify on which Excel version and platform do you work.

[#3]

@Dave_R1640 

Here is a simple formula to do this.

=IF(G5>0%,TODAY(),"")

Please consider, as Mr. Baklan has already informed you that the date will change depending on the day (today) and cannot be fixed on the previous day.

If you want that, you would have to resort to a VBA solution.

As you have already been told, please inform us about your Excel version and operating system in advance.

It helps a lot to get a solution proposal quickly and precisely.

NikolinoDE

I know I don't know anything (Socrates)

[#4]

@NikolinoDE working on Windows 365 in the office and EXCDEL 2019 from home. Both seem to be working on either platform. As you can see from the spreadsheet loaded I just need the date the percentage was added for the next cell

[#5]

Just tried this and it works perfectly. Thank you so much for helping

Dave

[#6]

I was pleased that we could help you.

I also wish you a lot of fun and success with Excel.