View Single Post
  #2   Report Post  
Andy Wiggins
 
Posts: n/a
Default

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