Question about Oracle Database Enterprise Named User Plus
I am trying to write a formula to calculate number of months in a date range any ideas?
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.
Posted on Jan 02, 2017
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.
Posted on Sep 06, 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
Tips for a great answer:
Oct 09, 2017 | The Office Equipment & Supplies
Oct 31, 2008 | Computers & Internet
Oct 17, 2013 | 1996 Italdesign Formula
May 09, 2009 | Microsoft Office Excel 2003 for PC
Mar 15, 2009 | Microsoft Office Excel 2003 for PC
Mar 12, 2009 | Microsoft Office Excel 2003 for PC
Jan 30, 2009 | Microsoft Excel for PC
Aug 25, 2008 | Microsoft Office Professional 2007:...
Sep 05, 2007 | Microsoft Office Standard for PC
112 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: