Just a wild guess. Have you tried enabling/disabling hardware acceleration ?
For pre-O365 versions see https://www.top-password.com/b…-acceleration-for-office/
For O365have a look at
I have faced this date problem many a times in my past applications .Hopefully I will come up with something to solve this problem too
To make your XL experience easy, DO NOT apply manual alignment to ranges you will use in formulas. Why ? Because text is always left aligned by default in the cells. So, if you see a left-aligned date, you immediately know you have to (probably) work on it
for Excel this is THE beginning of Time !!!
That I can do by selecting the A column from cell A2 to end in the raw data sheet, right click and convert it into dd-mm-yyyy
You might want to read https://www.excelcampus.com/fu…/how-dates-work-in-excel/ to understand how it works
Why did you start a new thread? It makes things confusing for the forum members
You can enter a range in the Holidays argument containing formulas that calculate variable holidays
I found one for Easter at https://www.contextures.com/exceleastercalculation.html
As for Labor day, it depends on the country I suppose. So, search the Net for other variable dates you need, there is probably an answer out there
I know, but you asked for a formula, so...
Same here
At lease now I know I am posting the queries correctly as none of my other posts are replied.
If so, you are probably not explaining clearly what you are trying to achieve in those other posts
Try
=DATE(LEFT(D10,4),MID(D10,5,2),RIGHT(D10,2))
pulled down and format as required
Please post a sample sheet ( no pics please). Thx
last question is probably more on the line with how to properly align a spreadsheet. I will have to change range ='Run Zones'!U8-AVERAGE(I5:I10)
I5:I10 range will change quite a bit for data calculations. Approx 10K rows. I am unsure of a good dashboard setup. Any ideas will be helpful.
You can replace the range reference using an Excel Table which will adapt automatically to the length of the range. ( there are other more convoluted methods)
See https://www.contextures.com/xlexceltable01.html on how-to
why does M11 say 1/25/1925? I cant make sense out of that.
That is because the cell is formatted as date. How Excel works with dates is explained e.g. here https://www.excelcampus.com/fu…/how-dates-work-in-excel/
Just remember that the underlying value is a number which Excel will show (format) however you wish ( e.g. a date) to the outside world without affecting the value.
So for Excel 1/24 is one hour and 1 is a day
In a cell, M11 say, enter
='Run Zones'!U8-AVERAGE(I2:I10)Now in your result cell enter
=DATEDIF(0,M11,"y")& " years "&DATEDIF(0,M11,"ym")&" months"Perhaps provide us questions and answers so we can check? ( this being said, I think hi-jacking old threads is not encouraged in forums)..
See the new formula with the yellow background, making use of SUMPRODUCT
BTW, are the blank rows necessary? If not they can be removed and you can make your range an Excel Table.
Then rebuild the formulas provided using the table references, so that in the future after any adding or removing of rows the formulas
and using this function to do the sum checking for the figures before finalize a financial report.
This is not really a checksum, subtracting a value from itself
