Wall Street Prep: Excel Crash Course
i,- i,- i,- i,- i,- i,-
Formulas Explained | 100% Correct i,- i,- i,- i,- i,-
|Latest 2025/2026 Update. i,- i,-
EOMONTH Function Definition: A function that allows you to
i,- i,-i,- i,- i,- i,- i,- i,- i,- i,- i,-
create monthly date headers. By outputting the last day of the
i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,-
specified month. i,- i,-
Explanation: Start by inputting the start_date into the first
i,- i,- i,- i,- i,- i,- i,- i,- i,-
argument. Then input how many months ahead or behind you
i,- i,- i,- i,- i,- i,- i,- i,- i,- i,-
would like to go from that start_date.
i,- i,- i,- i,- i,- i,-
EDATE Functioni,- Definition: Similar to EOMONTH but this i,-i,- i,- i,- i,- i,- i,- i,- i,-
return the exact date from the start-date, after the specified
i,- i,- i,- i,- i,- i,- i,- i,- i,- i,-
number of months. i,- i,-
Explanation: Start by inputting the start_date into the first
i,- i,- i,- i,- i,- i,- i,- i,- i,-
argument. Then input how many months ahead or behind you
i,- i,- i,- i,- i,- i,- i,- i,- i,- i,-
would like to go from that start_date.
i,- i,- i,- i,- i,- i,-
ISNUMBER Function Definition: A function that is useful
i,- i,-i,- i,- i,- i,- i,- i,- i,- i,-
criteria in IF Statements/Functions, and it is basically test to see if
i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,-
a cell has a number in it.
i,- i,- i,- i,- i,- i,-
, Explanation: Simply input value to check to see if value inputtedi,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,-
comes out to true or false.
i,- i,- i,- i,- i,-
ISTEXT Function Definition: A function that evaluates if there
i,- i,-i,- i,- i,- i,- i,- i,- i,- i,- i,-
is text inside a cell and will output TRUE or FALSE depending on
i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,-
the result. Also a useful criteria to add to IF statements/functions.
i,- i,- i,- i,- i,- i,- i,- i,- i,- i,-
Explanation: Simply input value to check to see if value inputtedi,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,-
comes out to true or false.
i,- i,- i,- i,- i,-
YEARFRAC Function Definition: A function that return the
i,- i,-i,- i,- i,- i,- i,- i,- i,- i,-
proportion of the year between two given dates, the start_date
i,- i,- i,- i,- i,- i,- i,- i,- i,- i,-
and the end_date. An optional basis parameter can be used do
i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,-
represent the number of days per month/year used to calculate
i,- i,- i,- i,- i,- i,- i,- i,- i,- i,-
the proportion of the year.
i,- i,- i,- i,-
Optional Basis Parameters: i,- i,-
1. 0 - or Omitted = U.S. 30/360
i,- i,- i,- i,- i,- i,- i,-
2. 1 - Actual/Actual
i,- i,- i,-
3. 2 - Actual/360
i,- i,- i,-
4. 3 - Actual/365
i,- i,- i,-
5. 4 - European 30/360
i,- i,- i,- i,-
Explanation: Simply input the start_date and the end_date with i,- i,- i,- i,- i,- i,- i,- i,- i,-
the desired basis argument and the function will output the
i,- i,- i,- i,- i,- i,- i,- i,- i,- i,-
proportion of the year between the two given dates. i,- i,- i,- i,- i,- i,- i,- i,-
i,- i,- i,- i,- i,- i,-
Formulas Explained | 100% Correct i,- i,- i,- i,- i,-
|Latest 2025/2026 Update. i,- i,-
EOMONTH Function Definition: A function that allows you to
i,- i,-i,- i,- i,- i,- i,- i,- i,- i,- i,-
create monthly date headers. By outputting the last day of the
i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,-
specified month. i,- i,-
Explanation: Start by inputting the start_date into the first
i,- i,- i,- i,- i,- i,- i,- i,- i,-
argument. Then input how many months ahead or behind you
i,- i,- i,- i,- i,- i,- i,- i,- i,- i,-
would like to go from that start_date.
i,- i,- i,- i,- i,- i,-
EDATE Functioni,- Definition: Similar to EOMONTH but this i,-i,- i,- i,- i,- i,- i,- i,- i,-
return the exact date from the start-date, after the specified
i,- i,- i,- i,- i,- i,- i,- i,- i,- i,-
number of months. i,- i,-
Explanation: Start by inputting the start_date into the first
i,- i,- i,- i,- i,- i,- i,- i,- i,-
argument. Then input how many months ahead or behind you
i,- i,- i,- i,- i,- i,- i,- i,- i,- i,-
would like to go from that start_date.
i,- i,- i,- i,- i,- i,-
ISNUMBER Function Definition: A function that is useful
i,- i,-i,- i,- i,- i,- i,- i,- i,- i,-
criteria in IF Statements/Functions, and it is basically test to see if
i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,-
a cell has a number in it.
i,- i,- i,- i,- i,- i,-
, Explanation: Simply input value to check to see if value inputtedi,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,-
comes out to true or false.
i,- i,- i,- i,- i,-
ISTEXT Function Definition: A function that evaluates if there
i,- i,-i,- i,- i,- i,- i,- i,- i,- i,- i,-
is text inside a cell and will output TRUE or FALSE depending on
i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,-
the result. Also a useful criteria to add to IF statements/functions.
i,- i,- i,- i,- i,- i,- i,- i,- i,- i,-
Explanation: Simply input value to check to see if value inputtedi,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,-
comes out to true or false.
i,- i,- i,- i,- i,-
YEARFRAC Function Definition: A function that return the
i,- i,-i,- i,- i,- i,- i,- i,- i,- i,-
proportion of the year between two given dates, the start_date
i,- i,- i,- i,- i,- i,- i,- i,- i,- i,-
and the end_date. An optional basis parameter can be used do
i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,-
represent the number of days per month/year used to calculate
i,- i,- i,- i,- i,- i,- i,- i,- i,- i,-
the proportion of the year.
i,- i,- i,- i,-
Optional Basis Parameters: i,- i,-
1. 0 - or Omitted = U.S. 30/360
i,- i,- i,- i,- i,- i,- i,-
2. 1 - Actual/Actual
i,- i,- i,-
3. 2 - Actual/360
i,- i,- i,-
4. 3 - Actual/365
i,- i,- i,-
5. 4 - European 30/360
i,- i,- i,- i,-
Explanation: Simply input the start_date and the end_date with i,- i,- i,- i,- i,- i,- i,- i,- i,-
the desired basis argument and the function will output the
i,- i,- i,- i,- i,- i,- i,- i,- i,- i,-
proportion of the year between the two given dates. i,- i,- i,- i,- i,- i,- i,- i,-
