Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Is bit masking restricted to long or integer type only?
I created a function that determines when events can happen on several different days based on what day of the week a month begins and how many days are in the month. My idea was to assign each date to a bit and when a date was passed to the function it would use bit masking to return whether the date was one of the selected dates. It works until a month with 31 days because 2^31 is larger than a long. I tried to use double type and got the overflow error. I tried to use the CDec conversion but nothing seems to work. I've searched Google and Deja and I not found a solution Thanks for any advice Merlyn |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
masking with symbol xxxx | Excel Discussion (Misc queries) | |||
Masking out characters in a cell | Excel Worksheet Functions | |||
masking credit card info when worksheet is printed | Excel Discussion (Misc queries) | |||
Display masking | Excel Discussion (Misc queries) | |||
Masking numbers | Excel Worksheet Functions |