OOPS.......Sorry friends,

Both of your formulas work fine......

Was taking Today() to calculate by mistake, whereas the date was
31-Aug-05...
replaced Today() with DATEVALUE("31-08-2005") to calculate the
results.....

Thanks & Take care!

Cheers.