static date Via vba based on if condition

[PrakashJ19]

Need support to update Static date in cell based on If Condition.

I m updating this formula in U3 Cell =IF(T3=$U$1,NOW(),"No")

Next day if i open the same file, i need old date not current date.

Thanks in Advance

[Bernie Deitrick]

You need to use VBA code to do that - this code will get you going, but I don't know whether you are changing U1 or T3 or if you have more than one cell with the formula. I have assumed that you are changing U1, that V1 is not used, and that you have a column of formula in T, starting in T3. If any of that is wrong, they you need to explain better...

1) Copy this code.
2) Right-Click the sheet tab of interest.
3) Select "View Code"
4) Paste the code into the window that appears.
5) Save the file as a macro-enabled .xlsm file.
6) Make changes as needed

Please Login or Register  to view this content.

[Sintek]

Could use a helper cell...

Please Login or Register  to view this content.

[maniacb]

Here is another approach based on the same principle Bernie mentions above. I assume this is needed for only one cell.

Please Login or Register  to view this content.

[PrakashJ19]

Thanks a Lot Bernie Deitrick , sintek and maniacb

Attachment 733616 Here is my requirement. based on Candidate name and which round he is in based on drop down, the system date should change accordingly.

[Sintek]

Invalid attachment...See Top Yellow Banner re sample upload...

[PrakashJ19]

Thanks for the update. Please check i have attached sample file

[Sintek]

If this is not working then please explain in a bit more detail what it is you are wanting to achieve...step by step

Assumes all headings are available...

Please Login or Register  to view this content.

[PrakashJ19]

Thanks a Looooot Sintek , Its working Great. One small request. In a Row , if i change the Round from Round 2 to Round 3. The Old Date in Round 2 should Erase and current date should appear in Round 3. Thanks Thanks Once again. thanks in Advance.

[Sintek]

Insert red snippet...

Please Login or Register  to view this content.

[PrakashJ19]

Thanks Thanks a Lot Sintek for your continuous support. You have attached one Excel "Copy of TEST.xslm" in that If i delete cell value in Column B(Dropdown) all dates updated in Row (C to G) Should clear.

I m new to VBA, so that i m asking. Dont mistake me for asking more validations.

[Sintek]

Please Login or Register  to view this content.

[PrakashJ19]

Thanks a Lot Sintek. you are Awesome. Thanks for you Continuous Support.

[Sintek]

.........................
Thanks.png