ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   in excel tel diff. b/w 01/05/2006 and 28/02/2002 date wid formula (https://www.excelbanter.com/excel-worksheet-functions/55254-excel-tel-diff-b-w-01-05-2006-28-02-2002-date-wid-formula.html)

kanwar sharma

in excel tel diff. b/w 01/05/2006 and 28/02/2002 date wid formula
 
please let me know immediately as am workin and whole thing depends on th
eformula am unable to get it

Nick Hodge

in excel tel diff. b/w 01/05/2006 and 28/02/2002 date wid formula
 
Kanwar

If you want the number of days, simply just take one from the other and
format the result as general.

=A1-B1

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"kanwar sharma" <kanwar
wrote in message
...
please let me know immediately as am workin and whole thing depends on th
eformula am unable to get it





All times are GMT +1. The time now is 08:59 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com