How to remove Sat/Sun?
I'd like to create dates that span multiple years. These dates are every day in each year sequentially.
If I start with 1/1/2000 and want to create every day up to 1/31/2005, can I start in A1 with 1/1/2000 then A2=A1+1 and drag that cell until I reach 12/31/2005? Does Numbers handle those calculations correctly?
If that is possible, how do I then strip out all Saturdays and Sundays so I'm left with only Mon-Fri?