Question about Oracle Database Enterprise Named User Plus

# Calculate number of months in date range

I am trying to write a formula to calculate number of months in a date range any ideas?

Posted by on

## 6 Suggested Answers

Hi,
A 6ya expert can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
The service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
Good luck!

Posted on Jan 02, 2017

Hi, I guess you mean vacation accrual. It's hard to help you here, without knowing the exact accrual formula. However here are some tips: Set up a column with the start date for each employee and use the today() function to get today's date. You can use the days360() funtion to calculate the number of days between two dates, assuming regular 30 days/month. For more date related functions, click on the Fx (letter f with an subscript x) to the left of the value/formula entry field at the top of the spreadsheet. Thsi gives you a wizard with a list of functions. Select the Data/Time group and you see all available functions and can interactively pull them together. Good luck K

Posted on Sep 06, 2007

SOURCE: EXCEL DATE RANGE FORMULA

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

SOURCE: Problem with formulas

You may want to try =COUNT(A1:C9) for example. In brackets type the range of cells you want to count and excel will give you the number of cells that contain numbers.

Posted on Aug 19, 2008

SOURCE: Need excel solution

As stated, the forumla solution in is
= (Due Date - Create Date) x 24

However, the key is that the result cell (where the formula is) should be formatted using the 'general' format, not date/time. So, I think in this example, the result should be 730.65 hours

Posted on Feb 19, 2009

To calculate the difference in Years use =Year(c,r)-Year(c,r)
To calculate the difference in Months use =Month(c,r)-Month(c,r)
To calculate the difference in Months use =(c,r)-(c,r)

c= column, r= row

You will need to format the source cells as dates

Posted on Mar 15, 2009

×

my-video-file.mp4

Complete. Click "Add" to insert your video.

×

## Related Questions:

### How can I calculate the EMI of a home loan of 90 lacs?

Banks and Non-Banking Financial Companies use the following formula to calculate EMI of a home loan. This is the formula for calculating compound interest. Applying the same formula for a home loan of Rs 90Lakhs, we get,

EMI = [P x R x (1+R)^N]/[(1+R)^N-1]

Where,
P= Amount borrowed- Here, it will be 90 lakhs
R= Rate of interest per month
N= Number of months in the home loan tenure

Going by the current lending rates followed by the financial institutions, we will consider R to be 9% per annum (to be converted to % per month) and for the loan tenure, we will take 20 years/240 months.

Substituting all values in the above formula, the home loan EMI comes out to be Rs 80,975 per month.

You can easily calculate the EMI for your home loan for any bank or NBFC using a free online Home Loan EMI calculator. You can also find this handy tool on the online portals of most banks and NBFCs. All you have to do is feed in the values in the respective fields and receive the answers.

Oct 09, 2017 | The Office Equipment & Supplies

### My MS Excel vlookup function ASCII type table contains both upper case and lower case letters, characters like ( and % or *, and numbers. It seems to return the numerical equivalent of upper case letters...

Correct a #N/A error Show All Hide All This error occurs when a value is not available to a function or formula.
1. Optionally, click the cell that displays the error, click the button that appears , and then click Show Calculation Steps if it appears.
2. Review the following possible causes and solutions. Missing data, and #N/A or NA() has been entered in its place
Replace #N/A with new data.
Note You can enter #N/A in those cells where data is not yet available. Formulas that refer to those cells will then return #N/A instead of attempting to calculate a value.
Giving an inappropriate value for the lookup_value argument in the HLOOKUP, LOOKUP, MATCH, or VLOOKUP worksheet function
Make sure that the lookup_value argument (argument: The values that a function uses to perform operations or calculations. The type of argument a function uses is specific to the function. Common arguments that are used within functions include numbers, text, cell references, and names.) is the correct type of value — for example, a value or a cell reference, but not a range reference. Using the VLOOKUP, HLOOKUP, or MATCH worksheet function to locate a value in an unsorted table
By default, functions that look up information in tables must be sorted in ascending order. However, the VLOOKUP and HLOOKUP worksheet functions contain a range_lookup argument (argument: The values that a function uses to perform operations or calculations. The type of argument a function uses is specific to the function. Common arguments that are used within functions include numbers, text, cell references, and names.) that instructs the function to find an exact match even if the table is not sorted. To find an exact match, set the range_lookup argument to FALSE. The MATCH worksheet function contains a match_type argument that specifies the order the list must be sorted in to find a match. If the function cannot find a match, try changing the match_type argument. To find an exact match, set the match_type argument to 0.
Using an argument in an array formula that is not the same number of rows or columns as the range that contains the array formula
If the array formula (array formula: A formula that performs multiple calculations on one or more sets of values, and then returns either a single result or multiple results. Array formulas are enclosed between braces { } and are entered by pressing CTRL+SHIFT+ENTER.) has been entered into multiple cells, make sure that the ranges referenced by the formula have the same number of rows and columns, or enter the array formula into fewer cells. For example, if the array formula has been entered into a range 15 rows high (C1:C15) and the formula refers to a range 10 rows high (A1:A10), the range C11:C15 will display #N/A. To correct this error, enter the formula into a smaller range (for example, C1:C10), or change the range to which the formula refers to the same number of rows (for example, A1:A15).
Omitting one or more required arguments from a built-in or custom worksheet function
Enter all arguments (argument: The values that a function uses to perform operations or calculations. The type of argument a function uses is specific to the function. Common arguments that are used within functions include numbers, text, cell references, and names.) in the function.
Using a custom worksheet function that is not available
Make sure that the workbook that contains the worksheet function is open and the function is working properly.
Running a macro that enters a function that returns #N/A
Make sure that the arguments (argument: The values that a function uses to perform operations or calculations. The type of argument a function uses is specific to the function. Common arguments that are used within functions include numbers, text, cell references, and names.) in the function are correct and in the correct position.

Oct 31, 2008 | Computers & Internet

### I need to add a year to dates on excel spread sheet there are more than 440 diffrent dates....Please help?

I assume that the dates you want adjust are in date form and are in regular columns (or rows).
If so, then you can use a formula like this =DATE(YEAR(A3)+1,MONTH(A3),DAY(A3))
where the original date is in cell A3.
You can then copy this formula to calculate all the new dates you need, and then copy the results back over the original dates as VALUES.

Oct 17, 2013 | 1996 Italdesign Formula

### Calculate Quarters between any two dates

not sure if this is what you are after entirely but should at least help you out some what

=DATEDIF(A3,C3,"m")/3

As you said you cant just divide by 3 but I have divided the formula by 3 to see how many 3 months will go into the output you could maybe have another formula to divide it by 2 to see if it will divide by 2 to see if you get a whole number or not, if you do then you can just return the first part before the dot ( using split function ) and if the value is less then 1 then obviously the 3 months has not passed between the 2 dates

May 09, 2009 | Microsoft Office Excel 2003 for PC

### How to calculate the difference of two dates by year, month and day using the formula in excel?

To calculate the difference in Years use =Year(c,r)-Year(c,r)
To calculate the difference in Months use =Month(c,r)-Month(c,r)
To calculate the difference in Months use =(c,r)-(c,r)

c= column, r= row

You will need to format the source cells as dates

Mar 15, 2009 | Microsoft Office Excel 2003 for PC

### Calculation of end date in format dd/mm/yy

Assuming you put the start date in cell A1, put this formula:

=DATE(YEAR(A1),MONTH(A1)+15,DAY(A1))

in the cell where the result wanted to be appeared.

P.S.: If this information was helpful, please rate this solution.

Mar 12, 2009 | Microsoft Office Excel 2003 for PC

### Converting date of a month to last working day of the month

use the below formula to get the date of the LWD (Monday thru Friday) of the month.
Assumed that if the date in cell A1 is 6-May-2005. then formula will be
=DATE(YEAR(A1),MONTH(A1)+1,0)-(MAX(0,WEEKDAY(DATE(YEAR(A1),MONTH(A1)+1,0),2)-5))

Jan 30, 2009 | Microsoft Excel for PC

### Formula for calculating the days beween months

for example, cell A1 has date (01-01-2008) and cell A2 has current date (08-24-2008) and cell A3 shows total days, is that you want to know? if yes, apply formula as under...

cell A3......(properties set as General to show digits)................ =SUM(A2-A1)

Aug 25, 2008 | Microsoft Office Professional 2007:...

### Problem with formulas

You may want to try =COUNT(A1:C9) for example. In brackets type the range of cells you want to count and excel will give you the number of cells that contain numbers.

Aug 19, 2008 | Computers & Internet

### Creating a holiday accrual spreadsheet.

Hi, I guess you mean vacation accrual. It's hard to help you here, without knowing the exact accrual formula. However here are some tips: Set up a column with the start date for each employee and use the today() function to get today's date. You can use the days360() funtion to calculate the number of days between two dates, assuming regular 30 days/month. For more date related functions, click on the Fx (letter f with an subscript x) to the left of the value/formula entry field at the top of the spreadsheet. Thsi gives you a wizard with a list of functions. Select the Data/Time group and you see all available functions and can interactively pull them together. Good luck K

Sep 05, 2007 | Microsoft Office Standard for PC

## Open Questions:

#### Related Topics:

112 people viewed this question

## Ask a Question

Usually answered in minutes!

Level 1 Expert

Level 3 Expert