well i didn't put everything i needed to so heres the rest...i have
cell L1 formatted with =NOW()+5 which creates what todays date is plus
5 days. that will setup a work week date, now in verious cell in the
work sheet for example if L1=NOW()+5 then it looks like this 2/25/2006
now in cell b15 i want the date to be Mon 20th, cell b23 would be Tue
21st all the way down to Friday taking away a day from L1 each time. my
work week starts on Monday and ends on Saturday, so for this week L1 is
2/25/2006 because today is the 20th and if i add 5 days to that i get
2/25/2006. i am using cell L1 as the primary date and want to
distribute that five day work period over other cells kinda like a
schedule.