software

I wud lik to know whtr thr is ne formula for date subtraction, ie., if i gv d
formula for sutracting 2dates, i nd to gt the d/f in mm/dd/yyyy format. i
doubt leap yrs and 30/31 days may pose an issue
--
Thanx n rgds
joe

If the older date is in A1 and the recent date is in B1, then:

=DATEDIF(A1,B1,quot;yquot;) amp; quot; years, quot; amp; DATEDIF(A1,B1,quot;ymquot;) amp; quot; months, quot; amp;
DATEDIF(A1,B1,quot;mdquot;) amp; quot; daysquot;

--
Gary's Studentquot;Joequot; wrote:

gt; I wud lik to know whtr thr is ne formula for date subtraction, ie., if i gv d
gt; formula for sutracting 2dates, i nd to gt the d/f in mm/dd/yyyy format. i
gt; doubt leap yrs and 30/31 days may pose an issue
gt; --
gt; Thanx n rgds
gt; joe

The formula is effective, i tried. But d thing is i didnt understand d logic.
Can u pls xpln how d func works n d appln of y, ym n md in 1st, 2nd n 3rd
parenthesis resp.
--
Thanx n rgds
joe