Remove weekends formula

Hi,

I'm trying to remove weekends from two date ranges, for example between 01/01/2005 and 28/03/2005. I've calculated the total number of days taken, but I've got no idea how to remove weekends.
Has anyone got any ideas how I can do this please?

Thanks in advance.

Assuming you have all your dates starting in A1, in an empty column (column F for instance), use =weekday(a1)

That will return a digit 1-to-7... 1 = sunday, 2 = monday etc.

Sort your table by column F. That will put all the mondays together, all the tuesdays together etc. All you need to do is delete the 1's & 7's, saturdays & sundays, and re-sort by column A.

Hi,

Thanks for the reply. Will this allow me to remove all the weekends that exist between the two dates ranges?