Recent content by ksnpc

Thanks! I really appreciate both of you taking the time to help me. [thanks]

Oh wow that is so much clearer! It never even occurred to me to use named ranges. I changed the Thru to =DATE(YEAR(From),MONTH(From)+6,31) but otherwise this was flawless. Thank you so much!

Oh - 5/31 you're right. That was one of my problems - figuring out how to account for the different number of days in the months. I was thinking of using the EOMONTH function (which I just learned about) but I'm really just using this as a conditional formatting formula so I might just put 31...

That is how I stated it. But I failed to state that they have the entire month 3 months before or 3 months after, etc. So the 3 months ahead at the beginning of the month to the 3 months following at the end of the month. So using your example. If the DOB is 2/7/1952 then they have from...

B15 is a date of birth field where a user enters a date. B16 is a date received field where a user enters the date an application is received. I am trying to figure out how to create a conditional formatting formula that I can use to flag B16 as red if an invalid date is entered. Here are the...

Another way is to right-click on the field and choose Format Field. The paragraph tab has a place to set indentations. You can set the first line to -.5 and left to .5 and it will create a hanging indent.

I had to adjust it slightly, but that got me what I needed. Thanks so much Mufasa!

Thanks for responding Mufasa, I believe all the non-standard names would all have a "." included. I'm afraid I don't have a master list though.

I would like to take a scientific name string a parse it into three separate columns - genus, species, and subspecies. Examples: Mustela nivalis --> genus: Mustela species: nivalis subspecies: <blank> Ophisaurus attenuatus longicaudus --> genus: Ophisaurus species: attenuatus subspecies...

Thanks!

I was asked to ensure that a user's java version was 1.5 or greater. I went to Java's test page and it reported 1.5.0_09, but when I typed java -version at the command prompt, it reported 1.3.1_01. I checked the Java control panel and it also reported 1.5.0_09. I was under the impression that...

I just wanted to post a follow up in case someone else has the same issue. Unfortunately, I ended up having to reinstall the OS to get rid of the "serious error" messages. The system restore seemed to work at first but the error came back. I tried the other solutions as well but they didn't...

I just finished that. I don't know why I didn't think of it earlier. I didn't realize how far back the problem went, the user just reported it Friday, but it had apparently been going on for awhile before that. She also told me that it's been happening most of the times she logs in, but not...

Hi, I have an XP Pro SP1 pc that has suddenly started giving me an error message on login that says something like "This system has recovered from a serious error". If I press the Send Error Report button it tells me it's an unknown driver error. There haven't been any hardware changes so I'm...

Thanks for the quick response. I wish it would let us use the same pool but when we get to the point where it complains that the pool exists it won't let us go any farther. Oh well, I'll try to run the merge and see what happens - it sounds like what I'm looking for. Thanks, Shauna