Inserting a Date depending on a spereate Cell Value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,
I'm wanting to have a formula that will automatically insert a date when a
seperate cells value changes.

Here's the senario...

Cell I36's value is currently "Pending" when it's value is changed to
"Completed" I want cell M36 to have the current date automatically inserted.
Currently when I36 is changed to one of three values I have a conditional
format change M36's color. I now also want a date inserted when it is
completed. I tried to do a formula that inserts NOW() but everytime the day
is changed (such as... today is the 28th but tomorrow is the 29th if I use
NOW() it'll keep the value as the current day which tomorrow will be the
29th) How do I stop this or get around it??

Thanks In Advance,
Rob
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula not working 3
How do a set the current date to change in cell everyday 1
Excel In Excel how can I block the contenent of a cell? 0
Insert date when a cell is changed 3
Conditional formatting / Hide-when-Function in a range of 3 cells 2
STORE THE DATE & TIME THE VALUE HAS CHANGED IN A CELL 1
Paste Values in linked Cells Only 4
Insert Date 3

Back
Top