Microsoft Excel Question, make a changing variable static after a condition is met.
Basically, I have a project in one of my classes where we need to keep track of when we complete things and such. Well, so far I’ve been tracking it manually and I was hoping there was a way to have it do it automatically.
I have three columns: name of task, task complete?, and date completed. Name I obviously have to type in and the task complete column was so I could put an if statement in the date column so that IF(B2=”X”, date, ” “), with date being the thing I have to change every time I update something. It’s helpful when we complete a lot of things in one day cause I can just copy the contents and drag it down, but recently we haven’t and so I’m doing a lot of editing when it was suppose to be saving me time.
Anyway, I’m going to be doing this for the rest of the semester at least, so I was wondering if it was possibly for me to write something to take care of that. If there is an X in B2 (for example), I want ‘date’ to equal today’s date, and become static so that it doesn’t change when tomorrow comes around. Is that possible?
This open post was written 1 month, 1 week ago | V/U/S: 65, 0, 1 | Edit Post | Leave a reply | Report Post
Reciprocity (0) 
Since writing this post Demi may have helped people, but has not within the last 4 days. Demi is a verified member, has been around for 1 year, 8 months and has 5 posts and 63 replies to their name.
Invite Others to Help
A logged in and verified Help.com member has the ability to setup a Friends List and invite others to help with posts.