difference

Hello, I have two columns for dates, Start date and end date. I want to calculate difference in two dates but difference should be exclusive of all Sundays and all First and third Saturdays falling in between those two days. Plz ensure its not alternate Saturday its First and Third Saturday...

I'm trying to calculate the difference in TY vs LY numbers in a pivot table. My set up is: Rows: Client Name Sale Date (grouping by month) Columns: Years (for the TY vs LY comparison) Sum Values: Sum of Sales For example <tbody> 2018 2019 Client 1 May 100 1000 </tbody> I want to...

in Excel 2010, how to (or is it possible?) to change the pivot table "% Difference From" to "LN Difference From" without VBA? That is embed LN( row b / row a) or any reasonable formula into the pivot table "__ Difference From" functionality without VBA?

in Excel 2010, how to (or is it possible?) to change "% Difference From" to "LN Difference From" without VBA? That is embed LN( row b / row a) or any reasonable formula into the "__ Difference From" functionality without VBA?

I amtrying to get the value of the difference between two times with the code below. tdiff = ((CDate(Me.uf9a_tb_cend.Value)) - (CDate(Me.uf9a_tb_cstart.Value))) - 0.5 .Cells(drow, 5) = Format(tdiff * 24, "0.0") Me.uf9a_tb_cend.Value = "3:00 pm"...

What's the difference between Stop and Debug.Assert in VBA code? Thanks

I need a formula for cell Q8 that looks at cell E8. If E8 ispopulated, place an x in cell Q8. If itmakes a difference, cell E8 has a formula that reads from another tab withinthe same spreadsheet. Thanks in advance

Hello, Iam trying to calculate the days between failures in column E. My goal is to beable to take the difference between the respective date in column A and get thedifference between the date previous cell. Theproblem I am running into is being able to do this considering I want to beable to...

hello im trying to make a macro so that if the "raw data" tab has more rows than the "calculations" tab, more rows will be added according to the difference. if the opposite is true, then delete the rows above....here's what I have so far, but the resize propert doesn't work with negative...

Hi Guys I am trying to write a formula to get the number of days between two dates , i also want to state if both dates dates are the same then return value 1 else o bring back the difference I have created the date difference formula below how can i add an if statement to return 1 if dates...

I have a pivot table with clients ("Client") and dates visited ("Date"). In the Rows I have Client and below that Date. In the Values field I have Date and formatted it to be Show Values As - Difference From - [previous]. Works fine. However, doing the same set up when the same table is...

<tbody> Date 1 Date 2 Difference 21/01/2019 08:45:03 <colgroup><col width="155" style="width: 116pt; mso-width-source: userset; mso-width-alt: 5668;"> <tbody> 1/22/2019 11:01:27 AM </tbody> </tbody> Hi, I need some help I trying to create a formula between two date /...

I have someone that doesn't need to make a payment until after they reach $15,000 year to date. However, if they reach it within a month, I need to only charge them the difference, and then every month after needs to be what they actually owe. I am trying to figure out the formula where these...

Hi, i have an Excel file here on shared drive when i view the file on my computer with all the formulas i get the Report with correct values displayed, but when i view this on another Computer. the values Change and i get different values displayed, not very big difference but maybe 1-5%...

If, vlookup calculation? Hi everyone, I'm trying to streamline a process where we compare the difference in prices (annually) on a spreadsheet without copying all the data onto 1 worksheet. We have a data extract (Columns A:L) with 2 work sheets in the extract (labelled current and last...

In Cell A1 I have text Start Time and Cell A2 I have text Now. Cell B1 contains the start time (manually entered) and cell B2 contains the NOW() function. Cell B3 subtracts the difference between cells B2-B1. All that works as expected. Now the issue, I need to take the difference convert it to...

Hi experts! I'm new to the Power BI world and I have a job to do, but I can't find the way to do that... If you could guide me, would be great! I need to obtain the time difference in minutes between a row and the one that follows. I would like to use the field "DATE" to calculate and maybe...

Hi, May be obvious but I have noticed in a file I'm working in, if you do a sheet calc (Shift+F9) the check that is built in is zero. However if you do an F9 calc, i.e. the whole file, a difference appears even though nothing has changed. My guess is something to do with iterative calculation...

I took a vehicle car loan for $777,700 at 8.85% for 7 years. I used PMT and got a monthly payment of $12,453. The bank has a payment of $12,473 I inquired the bank why the difference and they said it was the difference between 360 days vs 365. I don't know what is this. How do I calculate it...

Hello, I am trying to compare 2 columns of data and looking for the difference in column A in relation to data in column B. For example, A...........B 6610 164513 6610 164513 6520 164513 I want to identify the row that has 6520. Hope that makes sense. How do I write...