Sorry for the delay!! Thank you very much. Worked Perfect!
No I do not know how to do that? Could you help.
Great Idea; although it does not automatically undo what it did if you enter another date. I would have to re-run the filter each time.
Any other ideas?
In one cell I enter a year (A1); then i have 20 rows listing that year +1 (A3:A23). Also there is an IF statement were if the value in the cell is greater than the current year it will make the value 0 (zero).
So all that is set; just wanted to give you a base.
What I am looking to do is if, lets say the last 5 rows have the 0 in the to have the entire row "hide". So basically looking for a way to have it only show the years that appear and hide the rows that have a year of 0.
Is there a way to do that?
In cell A1 you will enter a date, 05/04/1952;
In cell A2 I would like it to extract just the year from cell A1; 1952. How do I do that?
In cell A3 I will use the =TODAY() function;
In cell A4 I would like it to extract just the year from cell A3; How do I do that?
Thank you very much for your help!!!
I am unable to locate a document regarding what I am trying to do. Do you know of any other references?
You all have helped me in the past; although my question is not about Excel I thought you might have some insight.
I am trying to set up an internal HTML document. I have everything done except one thing.
One the front page I want three question with Yes or No radio buttons.
Looks like this:
Are you married? O Yes O No
Is your spouse younger? O Yes O No
Have you ever been divorced? O Yes O No
Then there would be a submit button;
Upon submitting if there are any NO's it will direct you to a website, and if they are all YES's it will direct you to a different one.
How do you skip a cell?
If you have data in cell A1, press enter.
And want it to skip to cell A4. How would you do that with out a Macro shortcut key?
How do you do that Thomach?
I am bulding a document, and try to make it easy for the users to enter dates.
If i use to cells, could you give me an example, I am not sure what you meant.
How do you format a cell so that you can just type in 01011956
and it will display January 1, 1956?
Thank you all!
Thomach I used your solution and it works great and is most accurate. Thank you!
Sounds good, what you have so far looks great! Thank you.
Cant wait to see the new one.
Thank you "thomack".
I look forward to seeing your next post.
The 365.25 is not exact if there age is not evenly devisable by 4.
Say they are three years old and never had a leap year, but you divide by 365.25, it would not be accurate.
Thank you for the reply,
Unfortunately that does not work. All that does is take the number of days in between the two dates and divide them by 365. What about leap years? Is there a way to link it to a calendar so it would now were the leap years are, or divide it by years? Or make the calculation calculate the years, not the days? Thank you
How do you calculate an age in years?
In Cell A1 is the date of birth, 07/01/1933
In Cell A2 is the last date of the current year, 12/31/2003.
How do you subtract these to get a age in years. The correct answer would be, 70.5.
How do I get to this?
Second cell is A2, not AB.
If you have a date entered into cell A1; 01/01/1956, and want to subtract it from cell AB;12/31/2003 how do you get it to give you a year/age (47)?
What would it be to use a date in a cell?
If i enter any given date and want to add three months.
Cell A1 = 02/02/03
Cell A2 = A1+3 months????
How do I add months? Such as, todays date it 08/05/03, how do I add three months to make it 11/05/03?