Formula Days Left in Month

[vbjohn]

What is the best way to get the days left in the month excluding the weekend from todays date?


Also to get the count of the days in the month excluding the weekends?

For example: If today is Mar.15

WeekDays in the month: 22
WeekDays left: 12


Thanks.

[JaganEllis]

See the help on DateSerial re. getting the last day in the month. See the help on DataDiff for an example of days between two dates, and also how to exclude weekends.