Free Microsoft Excel 2013 Quick Reference

Excel Formula to calculate 90 days after hire date & Add Initial Pay Rate

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


Post your answer or comment

comments powered by Disqus
Hello all,
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.

Good Morning Everybody,

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.

Hi,

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

Thanks
Sunil

I maintain an Excel spreadsheet that is updated daily with the % gain/loss on
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.

I'm using Excel 2003 to track a project. There are several cells with
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?

Hello,

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:



I am wondering if there is a formula out there that will calculate the number
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.

i tried to write the formula to calculate the 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

i tried to write the formula to calculate the 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

Hi

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

Hello... I hoping someone can help me. I need a formula to calculate the difference between 2 dates excluding wkends. However, if a wkend is entered into to the start or end time, I would like the forumula to automatically start calculating fm Monday.

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!

I have attached the excel sheet with sample data. I need more generalised formula for flows per hour and flows per day since the existing formula in the sheet has many drawbacks:
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

I have a spreadsheet to track the timing of incoming files and a formula to calculate if the files arrive after their deadline. My problem arises when there is a file that is actually early but the formula reads it as late because it comes before midnight (i.e. the file is due by 2 AM and it arrives 3 hours early at 11 PM and the formula marks it as late). The dates are in the first column. Is there a way to create a formula that calculates the timeliness of the file based on the day? Thank you!

Hello, can anyone help me create a formulae to work out the following problem. I have 2 columns one contains dates and one contains currency matching to the dates. I would like to be able to enter a date in a cell and then calculate how many cells contain dates =90 days from the date entered and to then sum the total currency in the corresponding cells to these dates in the 2nd column.

I have to download a series of Excel files every day and without fail, when I download the first one and open it in Excel, Excel calculates cells on the sheet for 10 minutes or more. These aren't even that large, with only 3,000-4,000 rows, all containing text. After I open first file and wait the required ten minutes, opening the remaining files goes smoothly.

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!

I need a formula to calculate days between dates if before each other i.e.

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

Problem:
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)

I need a formula to calculate days between dates if before each other i.e.

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

I have spreadsheet in which I am trying to calculate the average number of days it takes for a product to ship. Column A contains the product name; Column D contains the number of days it takes the product to ship.

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.

we have set up a excel sheet to monitor our childrens grades. i would
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

How to use Excel 2000 to calculate mathematical formulas in a worksheet, the
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

(I'm using Excel 2007)

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 am suppose to calculate the days between 2 dates. However, leap yr would be 366 days but i have to formulate it so that no matter whether its leap yr or not, no. of days would be 365. So I would need to exclude 29 feb from every leap yr.

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!

I need help. I have created a spreadsheet to calculate interest.
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.