Hi All,
Is there a way to add a fraction years/months to a date?
E.g. H1 = "03/08/2021" + J1 which is "8.75" (where 8.75 is 8 years and 9 months) to give me a new date of "03/05/2029"
Would greatly appreciate any help on this !
Thank you
XERROR allows for conveniently generating most of the Excel errors as output to functions
With XERROR, it is very easy to generate all but four of the Excel errors as output to functions. Error types 0, 1, 2, 3, 4, 5, 6, 7, 8, 13, and 14 (i.e. #EXTERNAL!, #NULL!, #DIV/0!, #VALUE!, #REF...
I've been asked to calculate quarterly dollar spread based on start and end months.
I need it in this format.
removed bad image
Q1 calc is easy, but gets complicated (for me) on the rest. Any help would be greatful. Thank you.
<tbody>
start month
end month
total cost
q1
q2
q3
q4
3
7...
Try this:Here's what I need. 16 golfers put into 4 foursomes every day for five days. Need every golfer to play with each other golfer only once example: Day 1 (Joe -Skip-John-Pete) Day 2 (Joe -Scott - Jason- Harry) Day 3 ( Joe - Craig - Dave -Ken) Day 4 ( Joe - Zilly - Chris - Ed)...
4 Rows and 4 columns using numbers 1 through 16 insert in the 16 numbers in all cells using every combinations should be 5 possible groups
example A1=1 B1=2 C1=3 D1=4
A2=5 B2=6 c2+7 D2=8
A3=9 B3=10 C3=11 D3=12...
Hey All,
Quick question, I'm trying to calculate an ongoing IRR calc for a Private Equity Investment. For every period, I want to have an IRR calc up to that point. I need to somehow bring in the Fair Value of the fund on that date into the last cash flow of the IRR calc, otherwise the Cash...
Dear Excel community
Goal
I'd like to write a VBA macro using Solver.
I've no previous experience with macros.
I am looking for a dummy guide please.
Solver input
Set Objective: 'Calc optimised'!$J$14
To: Min
By changing variable cells: 'Calc optimised'!$E$3
Subject to the constraints...
I'm trying to create a loop to Find and Replace parts of formulas on my sheet labeled Output. With my current code, the replace function isn't working and I suspect it's trying to replace string functions only. I need this to alter the formulas. For example here is my array on Sheet1 with column...
Hi
There's something in my below code that causes the workbook to hang either during or immediately after the named procedures run and I strongly suspect the cause is either in the first or last 4 rows.
Private Sub Worksheet_Change(ByVal Target As Range)
CALC = Application.Calculation...
Hi,
I need help with this simple calculation in Excel that I am having difficulty with. I have tried couple of formulas so far and nothing is giving me the correct answer. The formulas are displayed in "MyProduct#1" and "MyProduct#2" columns.
So the "Original table" is what I am working with...
I have been using Excel since it came out. Never really had this issue come up. On large files with a lot of calculations, I keep the Calc off which allows me to insert rows, columns, cut and paste without delay. Files over 100 MB, multiple pages - not a problem. But now I have a spreadsheet...
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...
Hi there! So I am doing comparison reviews between a system calc and also using VBA to calc % based on criteria. Column T contains tenure. Our system rounds 4.9986 to 5.0, but 4.9900 would round down to 4.0.
Is there any way to properly round up / down to nearest whole # based on the above?
Ty!!
Long time browser, first time poster.
I've got a problem with a worksheet change event being triggered after I manually run a macro. The issue is that the change event actually happens before the manually run macro is even started. I've duplicated the issue in a much simpler example. Code...
Hello All, I have the following formula below. If I am using 6 30 2018 as the end date, the range the following provides is YTD (Jan1 18' to June 30 18'). Now need calendar year however so should I be using EOMONTH ? Or something else. Data!$A:$A is a column of monthly dates. B2 = 6 30 2018...
Hello,
I am trying to use a data table for inputs and another data table for calculations based on the Inputs from the Input Data Table. So therefore I wish to replicate the data exactly in the Calc table as it is in the Input table and then add columns for my calculations to the calc table. I...
Hi,
Is there a way to do a LIFO calc that reduces the older invoice and adds in the newest invoice? Making the average number of days outstanding change?
I'm using =if(d3*e3/f3+g3<>0,d3*e3/f3+g3,0)
Isn't there something similar to iferror(x,0) - that simply returns x as long as x is not an error.
A number of times - I need to test if something meets some condition and if it does I just want that value returned and if not I want a zero - but...
Good morning,
The below calc works as it should. I now need to add to this calc using the below as a criteria and counting total unique values from column $B:$B if they meet the below criteria.
=COUNTIFS(SURVEYS!$N:$N,"=Jacksonville",SURVEYS!$A:$A,"=ANSWERED")
Please help
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.