Software

Ask something
Discussion Locked

Excel help!!

0 helpful
5 replies

by david powell

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi everyone. I'm not great with excel and a user has asked a how to question. Quick run through, she has a spreadsheet with people who have started courses. She has a start date and an end date. What she has asked is if the spreadsheet can automatically tell her if someone has ended a course using todays date. For instance someone ended a course on the 13/07/10 the spreadsheet has 1 on the last column. Can anyone tell me how to do this?

Thanks
David

5 replies

by darryl~

This is the approach I'd use -

Somewhere on the spreadsheet where you'd like to display the current date (suppose it's cell H1) enter this statement =TODAY()
Then suppose the end date of the course is in cell B2.
Now suppose you want to enter the "identifier" in cell C2 that turns to a "1" if the End Date = Today's Date......enter this statement in cell C2 =IF(B2=H1,1)

Make sure all "date" cells are formatted as Date cells (and the same type of date format)

That should do what you want, but like I said, there are many ways to do it.

:)

by david powell

Thanks for this works perfect. Just one more thing. How do you do this for multiple cells i.e end dates are G3:G40 and todays date is Z2?

Cheers
David

by charliespencer

Try reposting this using the 'Ask a Question' button. The 'Discussion' forum is for matters of general discussion, not specific problems in search of a solution.

There are TR members who specifically seek out problems in need of a solution. Although there is some overlap between the two forums, you'll find more of those members in 'Questions' than here in 'Discussions'.

Additional benefits to the membership include:

1) The "Questions" forum provides for your feedback, by way of your being able to mark "helpful" responses as such. This does not necessarily mean that a given response contained the complete solution to your problem, but only that it served to guide you toward it. This is intended to serve as an aid to those who may in the future have a problem similar to yours, so that they might have a ready source of reference available, thereby perhaps obviating the need for them to repeat questions previously asked and answered.

2) The TR search function makes it difficult to find a particular "Discussion" or "Question" if it has not had a recent post; the two types get mingled in the listings. By keeping each type in their respective forums, it is easier for all to find what they are looking for.

by darryl~

I've found the following site quite helpful for many MS Office questions in the past.

http://office.microsoft.com/en-us/support/support-FX101825174.aspx?CTT=97

It has help categories for Office 2003, 2007, & 2010.

In regards to your question about copying the formula down a column.....if you use the formula Palmetto gave....if you click on the cell containing the formula & you position your mouse in the lower right corner of the cell you'll see a little black box appear (MS calls this a "handle")...just drag that little black box down the column & you'll have the formula copied down for you & it will automatically update the proper cell numbers in the formula.

But lit Palmetto said....it's best to use the Questions area for these type of questions.

This discussion is closed to new replies.