How to find the number of days between two dates in 365 day year (not in 360 days year) in Excel spreadsheet?
959916
I have no idea what this 360 day year you refer to is about.\n\nHere is a Microsoft article that may help you understand year calculations in Excel.\nhttp://support.microsoft.com/kb/214019\n\n///
143847
365 days w/o leap year\n366 days with leap year\n\nYou should know this since elementary.
77427
365 and a quarter (hence the leap year every four years)
424465
Actually there are 364 + 1/4 days in a year. This has to do with the time that our Earth takes to complete one erbit around Sun. Now we have an arbiterary time period called week which has 7 days. So we have a normal year of 7 x 52 = 364 days. This leaves us with one 1/4 day per year left unaccounted. To make up for it, we have a leap year (365 days, 29 days in February) every four years.
215288
There is another way to do this. Assuming your date is in cell A1;\n\nuse the formula =MOD("A1",7)\n\nThe result will come back as follows\n\n1 | Sunday\n2 | Monday\n3 | Tuesday\n4 | Wednesday\n5 | Thursday\n6 | Friday\n7 | Saturday\n\nIf you use it in conjunction with a VLOOKUP you can display the actual day.\n\nso in all \n\n=VLOOKUP(MOD("A1",7)  ,DayDataRange,2,FALSE)\n\n[I've named the lookup range DayDataRange]
630337
365 days in a non leap year (1997)\n270 degrees in a three-quarter turn.
337064
1 hour = 60 mins\n24 hours = 60 * 24 = 1440 mins\n1 day = 1440 mins\n365 days = 1440 * 365 = 525600 mins in a non leap year\n366 days = 1440 * 366 = 527040 mins in a leap year
102809
The Gregorian calendar, the current standard calendar in most of the world, adds a 29th day to February in all years evenly divisible by 4, except for century years (those ending in -00), which receive the extra day only if they are evenly divisible by 400. Thus 1996 was a leap year whereas 1999 was not, and 1600, 2000 and 2400 are leap years but 1700, 1800, 1900 and 2100 are not.
771065
Yes there is a better way than counting.\nBecause you have a leap year every four years, you can say that there are 365.25 days per year, as long as you deal in years that are multiples of four (which I will be doing). \n\nSo,  that means there are 52 + (1.25/7) weeks per year. \nThis is the same as 52 + (5/28) weeks per year. \nAs a top heavy fraction, this is 1461/28 weeks per year, and therefore there are 1461 weeks in 28 years. This is relevant because it is an exact number of weeks, the actual number 1461 doesn’t matter. This means that exactly 28 years ago, on 6 November, it was a Monday like it is today.\nSo, 6 November 1978 was a Monday.\n6 November 1950 was a Monday.\n6 November 1922 was a Monday.\n6 November 1894 was a Monday.\n\nWe have slightly overshot now, so we need to add on years. (I did this because it is easier to add than subtract, plus 1894 is closer to 1907 than 1922.)\nIn 4 years there are 208 weeks and 5 days (I found this by multiplying 52 + (1.25/7) by 4 to get 208 + (5/7) which is equivalent to 208 weeks and 5 days.)\n\nSo, 208 weeks after 6 November 1894, the date is 1 November 1898, also a Monday (because it’s an exact number of weeks later). 5 days later, it is a Saturday, on 6 November 1898.\nYou use the same process to find that it is a Thursday on 6 November 1902, and that it was a Tuesday on 6 November 1906.\n\nSince neither 1907 nor 1907 was a leap year (1904 and 1908 were), 365 days later it will be 6 November 1907.\n365 days is 52 weeks and 1 day. So, 52 weeks later, it is a Tuesday and the date is 5 November 1907, and the next day is 6 November 1907, and it’s a Wednesday.\n\nSo on 6 November 1907, it was a Wednesday.\n\nActually there is a slight problem with this method, because 1900 was not actually a leap year, but in this case it did not matter because the date is after 1900. You would have to adjust it very slightly for dates before 1900.
366298
There are 365.25 days in a year and one of every seven is a Saturday.\n\n365.25 x (1/7) = 52.17857142857142857142...\n\nSo, it is an irrational number.
876511
not adding in for the extra partal days each year 31536000\n\nadding in for the extra partal days each year 31556926.08
603849
I have not found a computation site that computes a date\ngiven number of days.  So...   \n I would compute the total number of days old I am and count back on the Christian calendar. Here is a starter.\n 2006    May 12\n 2005    365   days \n 2004    730   days  added 365 to previous total\n 2003   1096   days  added 366 to previous total(leap year)\n 2002   1461   days  added 365\n etc.  Leap years are evenly divisible by 4 and the leap\nday is Feb. 29. Normally February only has 28 days.\n When you reach a number of days that is greater\nthan your age of days, then count forward on the Christian\ncalendar while counting down on the days. When you reach\nthe days of your age you will have the date.\n  I'm sure there's an easier way but until you find it,\nthis is the best I can do.
953230
In the Gregorian calendar which is currently in use in most countries, there is a leap year every year divisible by four except for years which are both divisible by 100 and not divisible by 400. Therefore, the year 2000 will be a leap year, but the years 1700, 1800, and 1900 were not. The complete list of leap years in the first half of the 21st century is therefore 2000, 2004, 2008, 2012, 2016, 2020, 2024, 2028, 2032, 2036, 2040, 2044, and 2048. \n\nIn the Gregorian calendar, 97 years out of every 400 are leap years, giving the total number of days in 400 years as:\n\n 400 * 365 +100 - 3 = 146, 097\n\n\nHope this helps also check out this website.
974821
Here ya go....http://www.timeanddate.com/counters/newyear.html
206954
Excel stores dates and times in days.  If you subtract one time from another, the result will be in days.  Multiply by 24 to convert to hours.\n\nTo display tenths of an hour, format the cells to display tenths.\n\nTo always round up, add 0.05 hour.\n\nFor example, an employee starts work on March 12, 2006 at 8:05 and punches out at 5:11.  When you subtract the start time from the end time, you get 0.3796 days.  To get hours, multiply by 24: 9.11 hour.  To round up, add 0.05 hour: 9.16 hour rounds to 9.2 hour.
844854
I know how to do the number of days if that helps.\n\n=DAYS360(B2,C2,FALSE)\n\nCell B2 has the start date and Cell C2 has the end date with the formula in Cell D2.\n\nOK the month is =MONTH(C2-B2) but it will give you a result of 11 as it rounds to the nearest number.
1068494
350,000 days = 958 non-leap years, 330 days.\n\nThere will be 240 "February 29th's" during that time (those extra days get subtracted from the 330 days).\n\nSo, in 350,000 days, it will be September 13, 2964.