Adding/Subtracting Dates

Mar 10, 2008

1) To be able to get the current date in the format of 3/10/2008

2) To be able to take dates from 2 cells and get an integer value for the number of days between the two dates

View 9 Replies


ADVERTISEMENT

Adding/Subtracting Times

Sep 8, 2009

I'm making a table for myself to keep an eye on my hours worked every week. What i want is to be able to enter the start time and the end time and for Excel to find the time difference inbetween (not numerical mathematical difference) also i need to subtract a half hour from the time entered for monday thru thurs.

View 2 Replies View Related

Adding And Subtracting Time

Jan 23, 2008

I have the formula in my spreadsheet to compute time. It works only if the time in B1 is greater then the time in A1. I would to know if there is a formula to compute time with either negative or postive answer. For example if a carrier was set to load their papers at 12:02pm and ended up loading early at 11:50am I would like the result in C1 to be -12 or (12).

Currently I am using the formula: =HOUR(B1-A1)*6+MINUTE(B1-A1). Like I said, it is all good until someone loads early and then I get a "#NUM!"

Are there any other formula's that I can use or is there a simple modification to the formula I am using?

View 9 Replies View Related

Adding And Subtracting Based On Text

Jun 6, 2014

I'm having an issue with Excel. I believe I need to use a nested IF statement but I can't get it to work properly.

Starting Total = 50
Col A Col B Col C
20 IN 70
40 OUT 45
35 IN 80

What I am trying to achieve is if col B says in then add col a to the col c total from the line above, if col c says out then subtract col a from the row above in col c.

I have worked out how to subtract or add in seperate formulas but i cant seem to get it to work in the same formula.

View 4 Replies View Related

Adding And Subtracting Date And Time?

Oct 17, 2011

I've tried a number of examples but I can't seem to get it to work. the desired results in column C.

10/17/11 12:00 PM10/17/11 1:00 PM1:0010/17/11 12:00 PM10/17/11 9:00 AM(3:00)10/17/11 12:00 PM10/16/11 9:00 AM(27:00)

View 4 Replies View Related

Userform - Adding Amount To One Cell And Subtracting From Another

Jul 10, 2012

I'm decently competent at VBA but no real experience with userforms. I have a very simple 3x2 table:

Type $Amount
Cash $xxxxxx
Product A $yyyyyy
Product B $zzzzzz

I want a simple userform that moves money between the products, ie the user selects a money amount in the form (ex: $1000) and that amount is added from one product and simultaneously subtracted from the other. Note that the amount selected would be subtracted from one product's current balance and added to the existing balance of another product. No new money is coming into the system.

View 6 Replies View Related

Subtracting Two Dates

Mar 27, 2009

What would the formula be for subtracting two dates to get the numbers of years, months? I cannot get my formula to work.

Also, can Excel take a telephone number such as (555)-555-5555 can place the phone number in another field such as 555-555-5555?

View 9 Replies View Related

Cell Totals - Adding And Subtracting Values Which Contain Letters?

Jun 19, 2014

I was wondering if it is possible to get the SUM function to:

1) Add numbers in cells that contain letters or no letters.

2) If there are brackets that cell would be subtracted from the total, again ignoring any letters.

For example:

A1 = 3 ABC
A2 = (3 ABC)
A3 = 4
3 ABC + (3 ABC) + 4 = 7

View 5 Replies View Related

Subtracting Dates :: Birthday

Feb 22, 2010

On my worksheet I have a date of birth formated yyyy-mm-dd. On my form, I want to be able to identify anyone younger than 16. I tried subtracting from today's date on the worksheet, but that didn't work too well for me.

View 2 Replies View Related

Subtracting Weekending Dates

May 30, 2007

I have a weekending date. I would like to subtract X amount of weeks from this date and end up with the weekending date less the weeks I subtracted.

View 10 Replies View Related

Subtracting Time Between Two Dates

Apr 17, 2012

I am trying to subtract 45min from the time 00:05, but the result i am getting is 0:40 which is wrong.

I am using below formula.

=TEXT(ABS(B3-$A$3),"-h:mm")

Actual timeTime minusResults00:0500:45-0:40

View 1 Replies View Related

Subtracting Dates (minus Weekends)

Apr 20, 2009

I attached an excel file for an example. Basically I am calculating on time shipping, but I want don't want Saturday and Sunday to coun't against us.I need G5 to equal 3 days. Right now when I subtract E2 from F2 I get 5 days. But we only work M-F, and Saturday and Sunday shouldn't count against us. How would I subract the days automattically, so it takes out Saturday and Sunday?

View 10 Replies View Related

Subtracting Early Dates To Get A Number Of Days

Sep 19, 2007

I wish to subtract the date 11/18/1877 from 11/16/1968 to get a result showing the number of intervening days but excel does not want to do it.

When I take 11/18/1900 from 11/18/1968 and format the result to get a number with no decimals the result is 24835 as it should be; but it does not seem to work for dates earlier than 1/1/1900.

View 9 Replies View Related

Subtracting Dates :: Percentage Of The Days Worked

Dec 1, 2008

I have a minor assignment at work. The manager has given me a sheet that lists each employee's start date, and he wants to know what percentage of them have worked here for more than 30 days, 60 days, 90 days, etc. I know a long way to do it, but there's several hundred names, and there must be a quicker way. Is an array formula the answer? I need a non-VBA answer, but I'm not opposed to learning a VBA method (no pun intended).

View 9 Replies View Related

Vba Type Mismatch When Subtracting Dates/times

Sep 27, 2006

Does anyone know why I get a type mismatch on the following? I am trying to subtract one time from the other to get the total hours worked.

Sub WorkedHours()
Dim vStart, vEnd As Date
Dim vHours As Integer

vStart = "11/09/06 22:00"
vEnd = "11/09/06 23:30"

vHours = (vEnd - vStart) * 24

End Sub

View 3 Replies View Related

Subtracting Dates Results In A Big Number When A Date Field Is Blank

Jul 11, 2009

How can I change the ....

View 14 Replies View Related

Taking Percent And Adding Subtracting Percent Formula

Sep 12, 2012

I have a percent 3.14%, that I want to show 15, 20 and 25% above and below that percent. I am showing below the results and then formula. The top calculation results in the same on both the left and right. However the -15,-20, -25% results are different. Which is correct.

3.14%

20% +/-
3.14%

0.63%
or
6.28%

1.57%

2.51%

[code].....

basic math, but I don't understand why the results are different.

View 3 Replies View Related

Adding Values Between Two Dates And Dates Are Also Derived By Formula?

Dec 9, 2013

I have attached an excel sheet for your reference. I have particular debit values that are to be added between the dates. And Dates are also derived by formula based of payment term.

The ones I need to modify is Highlighted in Yellow. The values to be added is in "Customer Statement" and in H Column

These dates also have formula by which there are derived

-------------------------Current Ageing-------------------------
Date Range

Bucket
Amount
Percent
Start Date
End Date[code].....

I am USing =SUMIFS('Customer Statement'!$A:$A,'Customer Statement'!$H:$H,"=" & E11) but does not work.

View 9 Replies View Related

Adding Or Subtracting One Month To A Month Number

Nov 12, 2009

I have forumlas that will look at this cell and take action of the month in a different cell is either 1 month greater (Frontmonth+1) or less (Frontmonth-1) than "Frontmonth". As we approach December I'm realizing that logic will breadown since the FrontMonth+1 would be 13, not 1 (January)

Is there a way to get excel to add 1 month to just the month number so that if Frontmonth = 12, Frontmonth+1 would return 1, not 13?

View 9 Replies View Related

Adding Dates

Mar 28, 2009

In this spreadsheet I am working on for calculating vacation time based on accrual rate. how to add pay period dates automatically based upon the first on entered. I have done this before in a personal budget spread sheet and this is what I have in that. First cell I enter the date Second and following cells I have the formula "=IF(DAY(E$8+7)>7,E$8+7,"")" Everything works perfectly. No matter what I put in the first cell the following cells will adjust and display dates 7 days later from the previous cell.

I am trying to do the same thing except pay period dates are 14 days apart so I put the same formula except change the "7's" to "14's). The problem I am having is that ONLY the first cell displays the correct date, the second displays a blank cell and the remaining displays "#VALUE!". What the heck is going on? I cannot figure out why this formula works in one circumstance but not the other.

I am not sure what I am doing wrong, but what I am trying to do basically is what ever I enter in the first cell, I want all remaining cells in the date column to enter the date of 14 days later. Example, I enter in the first cell 3/27/09, in the next cell I want 4/10/09 and in the next cell I want 4/24/09 to be entered and this all the way down.

View 2 Replies View Related

Adding In Excel Dates

Dec 29, 2008

it has various headings - but the ones I am stuck on are below.

BADGENAMEDATE Issued

He has set up a basic vlookup so that typing in his badge number also will type out his name. However, he also wants the current date to come up every time he does this.

As the names and badge number don't change and have no difference from row to row, how can I get it to date stamp it with a different date each time?

View 10 Replies View Related

VBA Adding Wrong Dates

Dec 22, 2011

The code is supposed to project review dates 1 month, 2 months and 3 months after the start date, but the first "cell offset" line on is projecting the next day instead of next month, its driving me nuts!!, the others are working fine

Code:
Sub reviews()
Dim cell As Range

For Each cell In Range("L1:L200")
If IsDate(cell) Then
cell.Offset(, 10).Value = DateAdd("m", 1, cell.Value)
cell.Offset(, 11).Value = DateAdd("m", 2, cell.Value)
cell.Offset(, 12).Value = DateAdd("m", 3, cell.Value)
cell.Resize(, 10).AutoFill cell.Resize(, 11)
End If
Next cell
End Sub

View 3 Replies View Related

Adding Numbers Using Dates

May 10, 2007

I have a spread sheet that shows the dates items were shipped. When trying to work out the value of parts shipped in a month using SUMIF I get the value zero, I believe this to be because (obviously), there are multiple dates of ships during the month, I therefore tried ignoring the day of ship in the SUMIF but this did not work, the date format is DD/MM/YYYY.

View 9 Replies View Related

Adding Dates Via A Calendar

Dec 14, 2009

I'm trying to limit the information people can put into my format and therefore to ensure they put in a the correct date etc i'm wondering if it is possible to have a calendar pop up to click on the date for a particular cell?

View 9 Replies View Related

Adding Hours To Dates

Feb 15, 2007

I'm having great difficulty adding hours to dates in Excel. In cell A1 I have a number which is calculated from a formula, it will normally return whole number values between 1 and 100. In cell A2 I have a start date and time i.e. 14/2/07 06:00:00 in cell A3 I want to add the number in A1 as hours to the date in cell A2. I am using the formula in A3 as =A2+TIME(A1,0,0) it seems to work okay for numbers that don't take the date onto the next day but if I try to add 24 hrs or 48 hrs for example the date still stays the same.

View 7 Replies View Related

Adding Weekly Dates Automatically

Mar 25, 2009

how i can automatically add a week to a start date i have in a rotas for the whole year?.

View 3 Replies View Related

Adding A Loop Of Dates To A Macro?

Jun 30, 2014

The way the code works right now is that I have it run as a few loops. it will first loop through the first worksheet in the array and delete what I need and then when that loop finishes it will run two macros that I have added in, then it will loop to the next worksheet in the array. right now it is only 2 sheets but eventually it will be many more. just working out the code for now. What I would like to do is in the second loop. my second macro in the code formats each page and, what I would like to do is add a date column to my code. I need to start at 1/05/2014 and then for the next iteration in the loop add 7 days.

[Code] ......

View 5 Replies View Related

Adding Up Bonus That Corresponds To Name And Dates

May 8, 2014

There are 5 columns.

Engineer name, attended site(date), report received(date), commercial/heating and bonus(gbp)

Engineers will only get a bonus if they send the reports in 1 day after attended site date for commercial, and 2 days after for heating. If the report is received past this window, they do not get a bonus!

Weekends do not count as a day!

This should be on one row per engineer. I then want to see how much "John Doe" is owed in any given month...

View 3 Replies View Related

Adding Weeks Or Months To Dates

Dec 17, 2006

a sample of my sheet first....

View 9 Replies View Related

Adding Time :: Dates Should Get Changed As Well

Apr 15, 2009

I am having a 2000 records of date and time in excel (see the below example). My query is I want to add 6 hrs to each Cell and accordingly the Date should get changed for e.g see the B Column after adding 6 hrs the data should look like this. I want an excel formula (don't want VBA Code) ...

View 9 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved