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 !
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.
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...
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
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.
Set Objective: 'Calc optimised'!$J$14
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...
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...
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...
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?
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...
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...
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...
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.