ExcelBanter - formula to obtain difference between two dates.

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - formula to obtain difference between two dates. (https://www.excelbanter.com/excel-worksheet-functions/94630-formula-obtain-difference-between-two-dates.html)

Onkar Raut

formula to obtain difference between two dates.

i need a formula/function to calculate the difference between two dates in
microsoft excel worksheet.

Toppers

formula to obtain difference between two dates.

=(EndDate-Startdate) and format cell as General [or Custom=d] to give
difference in days.

=(B1-A1) where B1=17/06/2006 and A1 = 0106/2006 will produce result of 16

HTH

"Onkar Raut" wrote:

i need a formula/function to calculate the difference between two dates in
microsoft excel worksheet.

Peter from Novartis

formula to obtain difference between two dates.

See the "Designate valid cell entries" in the Help.
The function lets you to select a list of menu entries - in the Help there
is a whole host of options.

Toppers pÃ*Å¡e:

=(EndDate-Startdate) and format cell as General [or Custom=d] to give
difference in days.

=(B1-A1) where B1=17/06/2006 and A1 = 0106/2006 will produce result of 16

HTH

"Onkar Raut" wrote:

i need a formula/function to calculate the difference between two dates in
microsoft excel worksheet.

All times are GMT +1. The time now is 01:30 AM.