No of days in month

[DATTATREYA]

Hi
I need help 20th March'11 to 5th May '11 48days 12days in March 30days in April 5days in May month wat formula shall I use (we using MS 2003) pls help

 

[ukmikeb]

Hi

This thread -

http://www.mrexcel.com/forum/showthread.php?t=527540&highlight=calculate+number+days

should help you.

 

[shg]

See example #4 in http://www.box.net/shared/7xm2kt408n

 

[DATTATREYA]

Hi
I am using 2003excel so could u pls send me 20030excel formula

 

[Ruddles]

To calculate the difference between two <DELETE></DELETE>dates, subtract the smaller one from the larger one.