id="info"

General discussion

Locked

Excel help!!

By David Powell ·
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

This conversation is currently closed to new comments.

5 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

I'm sure there are many ways to do this....

by Darryl~ Moderator In reply to Excel help!!

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 <b>=TODAY()</b>
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 <b>=IF(B2=H1,1)</b>

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.

:)

Collapse -

Or

by CharlieSpencer In reply to I'm sure there are many w ...

=IF(B2=TODAY(),1)

and eliminate H1 entirely.

Collapse -

Thanks works perfect.. just one more thing

by David Powell In reply to I'm sure there are many w ...

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

Collapse -

Repost as a Question.

by CharlieSpencer In reply to Thanks works perfect.. ju ...

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.

Collapse -

In addition to Palmetto's above suggestion....

by Darryl~ Moderator In reply to Thanks works perfect.. ju ...

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.

Back to Software Forum
5 total posts (Page 1 of 1)  

Software Forums