Dates

Resolved · Low Priority · Version 2003

Thu 29 Oct 2009, 16:24 Delegate Owen said...

Owen has attended:
Excel Intermediate course
Excel Advanced course

Dates

How do you work with two separate dates? For example find number of days between two dates?

Fri 30 Oct 2009, 09:13 Trainer Simon said...

RE: Dates

Hi Owen,

Thank you for your question and welcome to the forum.

Start the formula with equals, select the cell with the most recent date and then minus the cell with the second date in.

Then format the cell as a number to get the number of days.

I hope this answers your question.

Regards

Simon

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

Checking if a calculation adheres to Order of Precedence

When writing formulas you must make sure that results will be calculated as you intended.

Excel adheres to the standard order of precedence for calculations. It calculates percentages, exponents, multiplication, and division in this order before calculating addition and subtraction.

For example, =7+5*3 results in an answer of 22, not 36.

To force a calculation to be completed before another calculations, place the section in parentheses: =(7+5)*3 will result in 36.

To check how excel is evaluating a formula, click on the cell and select the 'Tools' menu, select 'Formula Auditing' and click 'Evaluate Formula'

In the dialog box click on 'Evaluate' to watch as each part of the formula is successively calculated.

View all Excel hints and tips