leap year

Hi all, Been a while... Thought i had it figured out, but discovered that Excel Worksheet formula and Excel VBA do not seem to calculate one year from a leap day the same. In a spreadhseet, i have : Which, in my mind, is correct and the value i want. However, when using the following formula...

Hi, I am in the process of creating a personalized budget (Office 365). I am using the following formula that works perfectly. I am planning on using this budget for the foreseeable future. How will I make provision for 2024 leap year? [=SUMIFS('Details 2022'!$D$2:$D$2001,'Details...

Hello everybody! As a newbie, I'm approaching Power Query and Power Pivot. After the initial successes, I am now stuck with a problem and hope for expert advice. I've already added my data to the Power Pivot data model. Date StorageLevel 01/01/2015 165.31 01/02/2015 164.98...

This is a problem I have run into many times over the last 25 or so years (since Excel first came out). When I use a date variable on a chart axis, I often would like to have a fixed multiple of years (1 year, 2 years, etc.) as the major axis interval; however, the number of days varies for any...

Is there a formula that separates leap year and regular year days between two dates? For instance, from 1/1/2011 to 5/1/2012. If you include the last day, then there are 365 regular year days and 122 leap year days. If you do not include the last day, then there are 365 regular year days and...

I have several dates that require me to be forward looking and I need to ensure it accounts for leap year. The example is A B C Year: 12/19/2012 Years after: 20 Existing Formula: =A(B*365) , Result is 12/14/2032 I am...

Hello all, I am curently revamping some financial spreadsheets for work, and have an issue I would like help with. Traditionally, we just change the date in the first column of the sheet, and drag it down, this wouldn't be a problem, except in the last 10 years, we have grown to about 80 sheets...