How do you find out days and month calculation in Excel?

Answer 1

Arithmetic works with dates and displays the results as days, so just multiply the result times 24 to get the approximate number of hours between the dates (Excel default format for dates assumes each day has a full 24 hours). If your oldest date is in A1 and your most recent date is in A2, use the following formula to calculate hours between the two dates: =(A2-A1)*24.

If you need to show exact hours between specific times for two dates, just format A1 and A2 to display both date and time (a standard option under cell format for dates SAMPLE: 1/1/09 12:00 AM).

Answer 2

The question is a little imprecise as the answer to "how many days is it since today" will always be 0 (i.e. it is always today). So you either want to know:

a) How to calculate how many days from a date in the past to today:

For example, let's say you have your date in A1, then in B1 put "=TODAY() - A1".

b) How to calculate how many days from today to a future date:

put in B1 "=A1 - TODAY()".

Answer 3

All dates in Excel are actually stored as a number representing the amount of days since the 1st of January 1900, with that date being 1. You can take any two dates and subtract the older from the more recent and get a number representing the amount of days between those two dates. If a date comes up, it represents what the date would have been that amount of days after the 1st of January 1900. All you have to do then, is change the formatting from date to number to get the actual number you want.

All dates in Excel are actually stored as a number representing the amount of days since the 1st of January 1900, with that date being 1. You can take any two dates and subtract the older from the more recent and get a number representing the amount of days between those two dates. If a date comes up, it represents what the date would have been that amount of days after the 1st of January 1900. All you have to do then, is change the formatting from date to number to get the actual number you want.

All dates in Excel are actually stored as a number representing the amount of days since the 1st of January 1900, with that date being 1. You can take any two dates and subtract the older from the more recent and get a number representing the amount of days between those two dates. If a date comes up, it represents what the date would have been that amount of days after the 1st of January 1900. All you have to do then, is change the formatting from date to number to get the actual number you want.

All dates in Excel are actually stored as a number representing the amount of days since the 1st of January 1900, with that date being 1. You can take any two dates and subtract the older from the more recent and get a number representing the amount of days between those two dates. If a date comes up, it represents what the date would have been that amount of days after the 1st of January 1900. All you have to do then, is change the formatting from date to number to get the actual number you want.

All dates in Excel are actually stored as a number representing the amount of days since the 1st of January 1900, with that date being 1. You can take any two dates and subtract the older from the more recent and get a number representing the amount of days between those two dates. If a date comes up, it represents what the date would have been that amount of days after the 1st of January 1900. All you have to do then, is change the formatting from date to number to get the actual number you want.

All dates in Excel are actually stored as a number representing the amount of days since the 1st of January 1900, with that date being 1. You can take any two dates and subtract the older from the more recent and get a number representing the amount of days between those two dates. If a date comes up, it represents what the date would have been that amount of days after the 1st of January 1900. All you have to do then, is change the formatting from date to number to get the actual number you want.

All dates in Excel are actually stored as a number representing the amount of days since the 1st of January 1900, with that date being 1. You can take any two dates and subtract the older from the more recent and get a number representing the amount of days between those two dates. If a date comes up, it represents what the date would have been that amount of days after the 1st of January 1900. All you have to do then, is change the formatting from date to number to get the actual number you want.

All dates in Excel are actually stored as a number representing the amount of days since the 1st of January 1900, with that date being 1. You can take any two dates and subtract the older from the more recent and get a number representing the amount of days between those two dates. If a date comes up, it represents what the date would have been that amount of days after the 1st of January 1900. All you have to do then, is change the formatting from date to number to get the actual number you want.

All dates in Excel are actually stored as a number representing the amount of days since the 1st of January 1900, with that date being 1. You can take any two dates and subtract the older from the more recent and get a number representing the amount of days between those two dates. If a date comes up, it represents what the date would have been that amount of days after the 1st of January 1900. All you have to do then, is change the formatting from date to number to get the actual number you want.

All dates in Excel are actually stored as a number representing the amount of days since the 1st of January 1900, with that date being 1. You can take any two dates and subtract the older from the more recent and get a number representing the amount of days between those two dates. If a date comes up, it represents what the date would have been that amount of days after the 1st of January 1900. All you have to do then, is change the formatting from date to number to get the actual number you want.

All dates in Excel are actually stored as a number representing the amount of days since the 1st of January 1900, with that date being 1. You can take any two dates and subtract the older from the more recent and get a number representing the amount of days between those two dates. If a date comes up, it represents what the date would have been that amount of days after the 1st of January 1900. All you have to do then, is change the formatting from date to number to get the actual number you want.

Answer 4

Put two dates into separate cells. Use a formula to subtract the older date from the newer date. You will get a date as a result of your formula. Then format that date as a number and it will show you the amount of days in between the two dates.

So say you have 4/3/2009 in cell A1 and 4/3/2008 in cell A2. In A3 you would put the formula =A1-A2. A3 will now have a date in it. Go to the Format menu, pick Cells and Number and General as the format. The date will now change into a number and that is the amount of days between the two dates.

Answer 5

Excel is capable of doing many kinds of calculations with dates, well beyond the scope of this answer. Dates are stored as numbers. You can add or subtract numbers and dates. You can find out how many days are between dates or do something like find out what date it will be in a set amount of days after a date. So if you put a date into a cell, such as A2, and wanted to add 10 days, you would have a formula like this:

=A2+10

The result, when formatted to be a date, will show the date that is 10 days after the date in A2. Lots of functions can be used to work with dates in Excel. There is a category of date functions, which you should explore. There are functions to do things like calculate the day of the week of a date, the last day in a particular month, the number of the current year, month or day and many other things. With some practice and experimentation, you will find all sorts of ways of doing calculations with dates. Someone with Excel knowledge will be able to show you lots of things you can do with dates, and there are many sources online for things you can do with dates and there is the help in Excel.

Answer 6

All dates in Excel are actually stored as a number representing the amount of days since the 1st of January 1900, with that date being 1. You can take any two dates and subtract the older from the more recent and get a number representing the amount of days between those two dates. If a date comes up, it represents what the date would have been that amount of days after the 1st of January 1900. All you have to do then, is change the formatting from date to number to get the actual number you want.

Answer 7

If you want to calculate the number of days between two dates simply subtract the earlier date from the later one.