Free Microsoft Excel 2013 Quick Reference

Hi everyone,

I am recurring to you guys again for your help. I am trying to find a formula which adds 90 to a hire date. I am using

I am recurring to you guys again for your help. I am trying to find a formula which adds 90 to a hire date. I am using

which gives me a new date after hire date. I don't know if this is correct. Also, I need another formula to add the Initial Pay Rate plus 90 days increase. I would greatly appreciate if there is another formula that can point to A2 (new hire) and if this employee is a new employee, than fill the rest E2 and H2. See attachment for better detais.

Again, Thank you for your help and knowledge.

- Excel formula to calculate vaction time
- Calculating 90 days from a specific date automatically. Microsoft Excel 2003
- Populate a formula to update leave days
- Excel formula to calculate % gain when adding cash equity to accou
- Excel 2003 formula to calculate business dates
- Excel Formula to Calculate Leadtime minus Weekend
- Formula to calculate # of days between dates, excluding holidays
- HOW TO CALCULATE THE DAYS?
- HOW TO CALCULATE THE DAYS?
- Excel formula to calculate percentage for hours worked
- Formula needed to calculate the difference between 2 dates excluding wkend
- Excel formula to calculate the average flow per hour
- Formula to calculate if files are on time
- Looking for formulae to calculate dates/money in seperate columns
- Calculating Cells when there are no Formulas to Calculate
- Need formula to calculate days between dates or back date
- Excel formula to calculate Target Grade
- Need formula to calculate days between dates or back date
- Formula to calculate average days to ship
- Students grades, formulae to calculate what grade is needed based.
- How do I use Excel 2000 to calculate mathematical formulas in a...
- Excel refueses to calculate my formula?
- Formulate LEAP yr to be 365 days in excel
- Need to calculate interest on invoices each day past due until paid, I have varying rates

i am trying to figure out an excel formula to calculate vacation time here is my company's policy:

Vacation time does not roll over.

years of service monthly vacation accrual total days/year less than 6 0.83 10 6 through 10 1.25 15 11 or more 1.66 20

new hire must complete 6 months. Ee will earn 1 day per completed month until the end of the calendar year, at the beginning of the following year ee will use schedule above not to exceed 10 days. if employee was hired after july 1st he must wait until 3rd year to use the schedule above.

I am using Microsoft Excel 2003.

I would like to know if there is a formula I can use to calculate 90 days from a specific date. For example:

I would like to calculate 90 days from the date of 12/07/2009 automatically.

I would also like to know is it possible to caluclate 90 (BUSINESS DAYS) from the date of 12/07/2009.

To anybody who might know the answer to this question, please answer at your earliest convenience. Thanks for your help.

Help me to generate a excel formula to update leave days between 2 dates or multiple days, refer attachment for more details.

Thanks

Sunil

my stock brokerage accounts. How do I change the formula to calculate the

accurate % gain in my stock portfolio when I add cash equity to one of the

accounts? If I don't change the cost basis in the formula, the % gain in the

account increases excessively because it thinks I have gained all of the

added money as interest over the preceding 24 hours. If I change the cost

basis to account for the new money added to the account, my % gain year to

date decreases (from what it was the day before adding the cash equity)

because the cost basis is now higher than it was the day before. I want to

be able to change the formula going forward each time I add cash equity, but

still have an accurate year-to-date % gain from interest I have earned.

Thanks.

formulas to calculate # of days prior to a set target date.

For example if I want to initiate an action 10 days prior to the target

date my cell reads "=A4-10" and it supplies the date. Is there a way

to have this calcuate in business days verses calendar days?

I am really stuck on a formula to calculate leadtime for jobs in my shop. The formula I have been using seems to work ok but when the job takes less than 1 day it gives me negative numbers. Any help would be greatly appreciated.

Here is what I use now:

of days between two dates, but exlclude holidays. I know there is a formula

that will calculate work days, but I need one to calculate all days of the

week, not just work days.

A14(starting) B14 (ending) days including starting & ending

1/30/2005 02/01/2005 =DAYS360(A14,B14)+1

but I just can get 2 days. In fact it should be 3 days. I found that if

there is 31 days

in the month, the case will be like this. I tried to change the days360 to

days363 in formula. But I am not allowed. tks in advance

Sue

A14(starting) B14 (ending) days including starting & ending

1/30/2005 02/01/2005 =DAYS360(A14,B14)+1

but I just can get 2 days. In fact it should be 3 days. I found that if

there is 31 days

in the month, the case will be like this. I tried to change the days360 to

days363 in formula. But I am not allowed. tks in advance

Sue

I am currenlt working on a speadsheet for clocked hours (in & out)

I have managed to work out the formula to calculate the total hours worked, now what i need to do is calculate the percentage of hours spend on site but for some reason the formula isnt working.

Please see example below:

Total hours on site 08.10hrs

Contracted Hours 10

% = ??

the formual i used for this was total hours on site/contracted hours*1 =

This formula should give me an answer of 81% but for soem reason its giving me and answer of 3.4%. can anyone shed any light on this? is my cell format wrong?

In Out In Out In Out Total allocated %

7:50 AM 10:00 AM 10:32 AM 1:30 PM 2:24 PM 5:26 PM 08.10 10 3.4

This is a copy of the information i am trying to work with...please help!!!

Thanks

Kate

I am currently using NETWORKDAYS(D2,E2,AZ2:BC2)-1-MOD(D2,1)+MOD(E2,1))... when a wkend date is entered the result is ####

Thanks!

1. At the end it shows a negative value and cant avoid it (since the number of rows is not fixed, I get this data from database by using a macro)

2. If the flow at any particular time( in this case say 19032012 00:36 is missing) fails then the whole formula for flow per hour goes wrong

Can I have a formula which calculates flows per hour depending on the time ( in this case 00:06 to 00:51)

Thanks in advance

So I ask, what am I doing wrong here with the first file that Excel tries to calculate the cells when there is nothing to calculate?

Thanks in advance!

18 Apr & 9 Apr = - 9 days

I can calculate the difference for say

13 Mar & 18 Apr = 36 days

but need a formulae to calculate both in a list

Col 1 col 2 col 3

13 Mar 18 Apr 36

18 Apr 9 Apr ?

3 Mar 30 Mar 27

Thanks any help would be appreciated

Current Grade 94.1 - Target Grade 96.5

I need a formula that will calculate what grade is needed to maintain to

achieve target grade from current grade. Their is only 7 months left and

only 1 test per month.

So what grade do I need to maintain to achieve my goal grade at the end of

the year? (Excel Formula)

18 Apr & 9 Apr = - 9 days

I can calculate the difference for say

13 Mar & 18 Apr = 36 days

but need a formulae to calculate both in a list

Col 1 col 2 col 3

13 Mar 18 Apr 36

18 Apr 9 Apr ?

3 Mar 30 Mar 27

Thanks any help would be appreciated

For example, assume I have 5 shipments of Widgets.

Shipment 1 took 10 days to ship

Shipment 2 took 20 days to ship

Shipment 3 took 25 days to ship

Shipment 4 took 40 days to ship

Shipment 5 took 50 days to ship

The average days to ship would be 29 days.

The list contains about 1000 rows of different shipments and about 20 different products. I need to calculate the averge number of days it took each product to ship. Any help with a formula is appreciated. I have attached a workbook with sample data and expected results to clarify. Thanks.

appreciate the formulae to calculate what grade my child needs to make on the

final to make a 90 in a particular class, if the final is weighted at 55%.

His current grade is 80, as an example.

thanks,

mark

example I can give you to what it is that I am trying to do is put together a

chart that is going to automatically calculate a worksheet when I add numbers

to it.

I' ve seen it done, I just don't know how to do it, CAN SOMEONE PLEASE HELP

ME?

THANK YOU KINDLY,

Talia

Hi, I have this anoying problem with a Excel statistic file.

The problem is that in certain cells Excel refuses to calculate the formula that I have entered eg if I typ =8*8 in a cell it should say 64 but i doesn't it just says =8*8?

Before you say anyting, yes I have acivated the automatic calculation option and I have tried to press F9 but i doesn't help either?

Do you guys have a solution for this problem.

/Morris

I've tried using the formula I found in another forum:

=SUMPRODUCT(--(TEXT(ROW(INDIRECT(F4+1&":"&F5)),"dd-mmm")<>"29-feb"))

but when I input 01/01/2007 and 31/12/2007, the no. of days reflected was 364 days.

and when I input 01/01/2008 and 31/12/2008, the no. of days reflected was 364 days too. I have no idea what went wrong.

Anyone have any advise for me? Or any formula to recommend???

Need lots of help for Excel!!! Thanks in advance!

the problem is that I need to be able to differ between interest rates for each invoice.

the interest rates ie 18%/Yearly I will divide the percentage by 365 to accurately calculate daily rate.

I want the program to calculate from the first day it becomes past due until it is paid.

I have basic formulas to calculate the days past due as well as the interest rate does anyone know of

a way to combine all of these? I am not an excel expert. I appreciate any help

INV# BAL Due Date Interest Total Due

No luck finding an answer? You could always try Google.