Formula to list weekends only

Generate weekend dates only with a simple formula

In a a world where everyday is Saturday or Sunday….

Here’s a little puzzle for you…how can you use Excel generate a list of dates that are weekends only? For example, a list of Saturday Sunday pairs like this:

Example list of weekend dates only

Dave Bruns

Leave a Reply

Your email address will not be published. Required fields are marked *