0
How can you calculate an age with a date to date range in Microsoft Excel?
Wiki User
∙ 8y ago
Say the dates are in A2 and A3, with A2 being the earlier date. If you want their age based on the last birthday, no matter how close the next one is, you could use the following formula:
=INT( (A3-A2)/365.25)
Wiki User
∙ 8y ago
Add your answer:
Earn +20 pts
Are there any internet Date Time calculators that can calculate the exact middle date and time between two dates?
You can easily do this with Microsoft Excel or OpenOffice's spreadsheet module.
How do you time stamp a cell in Microsoft Excel?
You do not. Excel does not record the change date of an individual cell.
When Microsoft Excel invented?
Microsoft Excel doesn't have an invention date per-say. It was sold to them by another company under a different name Microsoft released it under a different name and with major improvement in 1987.
Calculate project end date in Excel 2003?
There is no simple answer to that, as it will depend on various factors. Each project is different. Without all of those factors, it is not possible to start to answer the question. It could be done in Excel, but a better application for managing a project is Microsoft Project.
What year is serial 379496?
The number 379496 is equivalent to the date 1/8/2939 in Microsoft Excel.
What are 5 different groups of functions provided by Microsoft Excel 2007?
Financial, Date & Time, Engineering, Statistical and Text.
How can you set validity date in Excel File?
Use data validation and set the condition to allow only the date range you specify.
How do you calculate 5 days from Monday?
One simple thing is that 5 days after Monday is always a Saturday. 5 days before it is always a Wednesday. After that, for a specfic date, you have to increment the dates. If it happens to be in the same month, it is easier than if the other date is in another month. Some computer applications will do it for you, such as Microsoft Excel.
How do you make a table of values and then graph the data?
use microsoft office excel ..!! tabulate the date and select the type of graph u want to plot :)
How do I get rid of weird dates in Microsoft Excel 2007?
If you do not like how the dates are formatted, then change the date format of the cell to whatever style you would like to display.
How do you stop a number changing to a date in a cell in Microsoft Excel?
Select the Cell and press Control + 1 or find format cell. Select the option under the "Number" tab "Text"
What day of the week was Jan 28 1977?
Friday. There are lots of ways to calculate this, but I just typed the date into MS Excel and formatted the cell to show the day of the week.
