Hi

if i take in column A (Date1) 31-MAR-11 ; in column B No of days are 31; in column No C there is formula which deduct no of days from column A date.
so answer is 28-FEB-11 (Date2); in column D the formula is =DATEDIF(C2,A2,"ym") & " Months "&DATEDIF(C2,A2,"md") & " Days"
which shows 1 Months 3 Days

how can i rectify this error. i think excel consider 31 days for the month of Feb

i will appreciate any help on this. for rest of date range it works fine for me.