PDA

View Full Version : skipping numbers



Tenspeed39355
03-20-2006, 12:00 PM
Good afternoon guys. I would like to set up a ss using numbers that run from -1 to -250 in row 2 starting at C3 thru IV3. I need to attach dates to the numbers but here is the problem. I need the numbers to run -1 thru
-5 skip 6,7 and start back with 8 thru 12. What I am trying to do is skip the weekend Sat and Sun. The reason for this is most of the web site I go to backchecking my ss against the numbers and dates will not match up.
This way I can match the numbers and dates with the web sites data.
Thanks for any help you can give me. It would take a long time to do this manually.
Max

mdmackillop
03-20-2006, 12:39 PM
Hi Max,
Enter formula in C2 and copy across
=IF(MOD(B2+2,7)=0,B2+3,B2+1)
Regards
MD

Tenspeed39355
03-20-2006, 03:03 PM
Thanks that will help a lot