If you have the Analysis ToolPak add-in enabled, try this:

For 01/07/2007 in A1
B1: =EDATE(A1,(8*12)+7)

For the number of days between those 2 dates, simple math works:
C1: B1-A1

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Tiya" wrote:


Hi to all

want to calculate date between....

i.e. Date = 01/07/2007

add 8 years and 7 months
so pl. help me for formula, for add 8 years and 7 months into date......

also if possible give me formul as calculate days between two date

Thanks