Jump to content

2020 is leap year, repeating 2-digit (sort of) number


shootingstar

Recommended Posts

Plan anything different this year?

Though we didn't really plan it to acknowledge 2020, we're planning another European trip, which will include area where dearie's family is from.  I'm just hoping the trip will be safe. That's all. 

I have no clue what to do with an extra day 'cause it's a leap year.

Link to comment
Share on other sites

The main thing for me that's different is that in my fiancial spreadsheet, I have a bunch of places with formulas that tell me what I can expect for the whole year by first determining what fraction of the year is completed.  The formula in each spreadsheet cell is basically something like (b4-aa4)/365, where b4 is the current date and aa4 is Dec. 31, 2019 and b4-aa4 is how many days have passed in the year.  There are other cells with slightly different formulas I also divide by the number of days in the year.

I had to look all through the 2020 spreadsheet I cut-and-pasted from 2019 and change 365 to 366.  When I get the energy - maybe if the Titans at Patriots game gets boring, I'm going to set up a cell designated: Days in this year, put 366 in it, and change all the other 366's in the spreadsheet to that cell's number so that next year I don't have to search for all the 366's I have to change back to 365.

P.S. If you need a spreadsheet formula to tell you how many days are in the current year (many so you don't have to manually change it each year):

Since we don't have to worry about a century year like 2000 being evenly divisible by 400 for almost 400 more years, this formula in a cell will generate 365 or 366 for the current year, getting every year before 2400 right:

=IF(MOD(YEAR(NOW()),4)=0,366,365)

YEAR(NOW()) generates the current year (2020 now), MOD (....,4) generates the remainder of dividing by 4. if it's 0, it's leap year (366 days), otherwise 365

So everywhere I have 366 in my spreadsheet, I can reference the cell (e2) with the IF(MOD formula and instead of =(b4-aa4)/366, I use =(b4-aa4)/e2 and the number of days in the year will always be correct:

image.png.59e8dfe571c22db4deb46a7515bfc744.png

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...