Question about Oracle Database Enterprise Named User Plus

# EXCEL DATE RANGE FORMULA

NEED TO FIND A FORMULA TO CALCULATE THE LEAGUE AGE OF PLAYER. THE PLAYERS BIRTHDAY IS 9/7/1997, THE PARAMETERS FOR  LEAGUE AGE ARE 5/1/1997 TO 4/30/1998.

Posted by on

### CNewton2

• Level 1:

An expert who has achieved level 1.

Hot-Shot:

An expert who has answered 20 questions.

Corporal:

An expert that has over 10 points.

Mayor:

An expert whose answer got voted for 2 times.

• Contributor

Assuming birthdate is in cell B2:

=IF(B2<DATE(1997,5,1),"Too Young",IF(B2>DATE(1998,4,30),"Too Old","OK"))

Posted on Oct 27, 2007

### Anonymous

Posted on Dec 14, 2007

×

my-video-file.mp4

× ## Related Questions:

### What is the age limit for little league?

(a) Little League (Major) Division: Any candidate with amateur status who will attain the age of 9 years before September 1, 2016, and who will not attain the age of 13 before May 1 of the year in question shall be eligible to compete in Little League Baseball (subject to the local league Board of Directors alignment ...

Aug 27, 2016 | Rawlings Youth Players Series 11" Little...

### How should I set the v-window when I enter my distance equation?

The Window parameters control the width and length of the graphing screen. The distance equation is a formula to use to calculate the distance between two points known by their coordinates. The window dimensions have nothing to do with calculations. Or maybe I don't understand the question.

Sep 25, 2014 | Casio FX-9750GII Graphing Calculator

### Do I need to get my son batting gloves for little league baseball?

Some people like to use gloves for batting if they are doing it often enough to cause callouses on the skin. They also help with gripping the bat but at a young age, they shouldn't have any problem. My daughter is an avid softball player, playing three to four times a week, and her hands are perfectly fine without gloves.

Jan 14, 2013 | Baseball & Softball

### How many people must be in a room before the probability that some share a birthday becomes at least 50 percent? Use different values of n in the formula and approximate to the nearest n. show all work.

With two people in the room, the probability that the second person shares a birthday with the first is 1/365 (let's ignore leap years for the time being). Thus, the probability that they DON'T share a birthday is 364/365.

Add a third person. The probability that this person does not share a birthday with either of the first two (assuming they don't share a birthday) is 363/365. Thus, the probability that none of the three share a birthday is (364/365)*(363/365).

The probability that a fourth person doesn't share a birthday with any of the first three is 362/365. Thus the probability that none of the four share a birthday is (364/365)*(363/365)*(362/365).

See the pattern here? The probability of the n-th person not sharing a birthday is (366-n)/365. Keep adding people and multiplying the terms together until the probability of no one sharing a birthday drops below 0.5 --- which is when the probability of at least one pair sharing a birthday climbs above 50%.

Since this sounds like a homework problem, you'll have to do the rest.

Apr 21, 2011 | Texas Instruments TI-84 Plus Calculator

### How do I use the Log button on this calculator? For example, I can't do the expression Log5(25) which equals 2. It turns out all funny.

The TI-30 XIIS, like most calculators, cannot do logarithms to base 5 directly. You need to apply the formula: To calculate the logarithm at base 5 of 25, you key in: 25 [log] [ ÷] 5 [log] [=]

Jan 11, 2011 | Texas Instruments TI-30 XIIS Calculator

### What button or formula do I use to calculate percentages

ok. first things first, percent mens, out of 100. you simply replace the percent with fractions. say you have \$400. your workers get 20% of the money made each day. 20 out of 100=1/5 of 100.so your workers get 1/5 of the money which is 400 divided by 5 wich equals 80. i hope this helps. if you still have trouble, serch on the internet for the formula for calculating percent.

Aug 05, 2010 | Adler Royal Royal 1228 Calculator

### Fibonacci formula won't graph, but will show table

Fibonacci sequence is the series of numbers 0, 1, 1, 2, 3, 5, 8, 13, 21, 34, ...
At first type Fibonacci equation in Y editor with condition x>=0 and then graphing it. See captured images with enlarged form of graph   Apr 11, 2010 | Texas Instruments TI-84 Plus Silver...

### How do I see the league table for the Vodacom League in Cape Town area

http://www.safa.net/index.php?page=logsnresults

1. League [select] 2. Season [select] 3. Province [select]
> view logs < for league table : > view results < for match results.
play on :-)

Sep 11, 2009 | Safa Audio Players & Recorders

### Sumif function....

Use the following formula as an array formula, you need to hit "Shift+Ctrl+Enter" after entering the formula. Lets say you have the Name in column "B", the Age in column "C" and the amount paid in column "D". Here is the formula.
=SUM((B2:B7="Abhilash")*(C2:C7>0)*(D2:D7))

It will calculate the amount paid if the name =Abhilash" and the Agr is greater than zero.

Apr 11, 2009 | Microsoft Works 8.0 for PC

### Excel formulas

=IF(A1 < 25,10/100 * B1, 5/100 * B1)

A1 is the Age of client
B1 is the car value

Oct 27, 2008 | Microsoft Excel for PC

## Open Questions:

#### Related Topics:

5,846 people viewed this question

Level 3 Expert