Formula for Last 30 Days Excluding Saturday, but including Sunday

I need to get the last 30 days including Sunday, but not including Saturdays. My current code is only counting workdays, and I cannot figure out how to include Sundays without including Saturdays.

A1:

Please Login or Register  to view this content.

A2:

Please Login or Register  to view this content.

A3:

Please Login or Register  to view this content.

ETC, ETC, onto Cell A30

Try

=WORKDAY.INTL(A1,-30,17)

Does this go into Cell A1? If so, what would go into A2?

The formula goes where ever you want it. Where you want the resulting Date.
A1 is the date your looking to subtract 30 from.

Please see attachment. I am not able to get a list of the last 30 days, excluding Sundays to display.

Please Login or Register  to view this content.

OK, I didn't understand that you were looking for the LIST..
I thought you just wanted to calculate what date was 30 days ago..

In A1, put
=TODAY()

then in A2 and filled down to A30 put
=WORKDAY.INTL(A1,-1,17)

Thanks this works.

Glad to help..

Just an FYI, the WORKDAY.INTL function is only available in XL2010+
If you share the book with others that don't have this version, then you'll need another method.

This method might even be better anyway

A1: =TODAY()
A2: =IF(WEEKDAY(A1)=1,A1-2,A1-1)
Fill down to A30