convert 360 days basis to 365 days basis in excel 2007 TBILLSYIELD function

Dear all kindly help me to convert the base of 360 days used by excel 2007 tbillyield functions.

regards.

Are you talking about =days360()? Have you try using =dateif() instead?

I'm pretty sure the 360 days is hard coded into the =TBILLSYIELD() formula, you may have to "roll your own".

Check here for more info and how to do the calculations:
http://office.microsoft.com/en-us/ex...010342949.aspx

Dear friend first of all i got another reply "360 days is hard coded into the =TBILLSYIELD() formula, you may have to "roll your own". from another member which i think more relevant. but simultaneously i am interest in the formula you mentioned, can you give me some example where you use this formula.

regards.

Thanks and i sent this query to microsoft help, lets see what their reply will come.

Dateif() computes the time and/or date between two dates. So Dateif(startdate,enddate,interval)


http://www.cpearson.com/excel/datedif.aspx