According to the Help file, the formula to calculate TBILLPRICE is:
100*(1-discount%*(Maturity Date - Settlement Date)/360).
Use this instead of the provided function and change 360 to 365.
--
Andy Wiggins FCCA
www.BygSoftware.com
Excel, Access and VBA Consultancy
-
"ASHAR ZUKA FAROOQI" <ASHAR ZUKA
wrote in
message ...
In Pakistan we calculate T- bill Prices on the basis of 365 yaers a day.
In
the formual of T-bill Price the basis of 360 days a year. So we found an
error of calculation. Please advice me.
Regards