calculate date between....

[Guest]

Hi to all

I want to calculate date between....

i.e. Date = 01/07/2007

add 8 years and 7 months
so pl. give me formula for add 8 years and 7 months into date...... if any

also give me formul for calculate days between two date

Thanks

Shital Shah

 

[Bondi]

Hi to all

I want to calculate date between....

i.e. Date = 01/07/2007

add 8 years and 7 months
so pl. give me formula for add 8 years and 7 months into date...... if any

also give me formul for calculate days between two date

Thanks

Shital Shah

Hi Shital,

Pearson has a good page with lots of good stuff on dates:

Adding:
http://www.cpearson.com/excel/datearith.htm

Between:
http://www.cpearson.com/excel/datedif.htm

Regards,
Bondi