LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Junior Member
 
Posts: 5
Default

Wow, m8, u blew my mind... Thanks a lot! This was my very first experience with an UBF function. I had to read additional info on the web in order to get how it works. =) I really appreciate your help.

Well, I managed to start this UBF. It does count the number of days correctly, but for some reason it fails 183 days check. I used it on one example and it told me that the company exceeded 183 days threshold even though the total number of days was less than 183 =(

Could you correct it for me please? Thank you in advance.

Cheers,m8.
 
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
Counting number of days in several periods ignoring repeating dates sergeten New Users to Excel 3 November 3rd 12 02:34 PM
Counting average number of days between 2 dates RobertK Excel Discussion (Misc queries) 3 September 19th 09 02:29 PM
Counting non-repeating dates SouthCarolina Excel Discussion (Misc queries) 8 May 23rd 06 07:50 AM
calculating number of three month periods between two dates... neil Excel Discussion (Misc queries) 3 May 21st 06 01:52 PM
Number of semi-monthly periods between 2 dates sforr Excel Worksheet Functions 15 June 16th 05 03:45 AM


All times are GMT +1. The time now is 02:45 PM.

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"