Question about Oracle Database Enterprise Named User Plus

Open Question

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

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

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.
goodluck!

Posted on Jan 02, 2017

Conficio
  • 9 Answers

SOURCE: 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

Posted on Sep 06, 2007

CNewton2
  • 27 Answers

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

  • 40 Answers

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

  • 35 Answers

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

RickOz
  • 145 Answers

SOURCE: How to calculate the difference of two dates by

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

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

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

1 Answer

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 blueup_clv.gifShow All bluedrop_clv.gifHide 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 ooui1_za06043871.gif, and then click Show Calculation Steps if it appears.
  2. Review the following possible causes and solutions. blueup_clv.gifMissing 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.
    blueup_clv.gifGiving 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. blueup_clv.gifUsing 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.
    blueup_clv.gifUsing 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).
    blueup_clv.gifOmitting 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.
    blueup_clv.gifUsing 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.
    blueup_clv.gifRunning 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

1 Answer

Need a formula to calculate length of service in excel


You could do a simple +NOW-START DATE

It would depend on the format of your start dates - i.e YY, DD/MM/YY as to the results you get.

Do want the results in years, months, days?




Jun 05, 2009 | Microsoft Excel for PC

1 Answer

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

1 Answer

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

1 Answer

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

1 Answer

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

2 Answers

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:...

1 Answer

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

1 Answer

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

Not finding what you are looking for?
Oracle Database Enterprise Named User Plus Logo

Related Topics:

112 people viewed this question

Ask a Question

Usually answered in minutes!

Top Oracle Computers & Internet Experts

robertmoore1

Level 2 Expert

179 Answers

Fred Block
Fred Block

Level 2 Expert

289 Answers

CNewton2
CNewton2

Level 1 Expert

27 Answers

Are you an Oracle Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...