LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 48
Default Define Basis

I was trying to explain the YEARFRAC function to someone. I use it and
always omit the Basis. But I couldn't really explain what the different
Basis values mean. Oh, I know it determines how the days are counted .. but
exactly HOW???

The online help doesn't explain the value at all, and so I was hoping
someone could give me a good definition on how to determine which Basis one
should use under which circumstances.

Thankx for any insight.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula via Define Name (not working) Edmund Excel Discussion (Misc queries) 3 May 16th 06 03:01 AM
Summarize employee attendance data on a weekly basis Hanr3 Excel Worksheet Functions 1 May 5th 06 04:57 PM
excel should allow me to filter rows on basis of the cell color heramb Excel Worksheet Functions 0 March 22nd 06 05:18 PM
Define name digicat Excel Discussion (Misc queries) 6 January 19th 06 05:54 PM
I can define a name, but I cannot use the name - menu Insert-Name-Use is blank Zdenek Moravec Excel Discussion (Misc queries) 4 April 15th 05 02:55 PM


All times are GMT +1. The time now is 04:25 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"