I'm looking for month to date that excludes today. I'm using this formula
Between DateSerial(Year(Date()),Month(Date()),1) And Date()-1
This works great except for when it's the 1st of the month. Can anyone give some direction on how to handle the change in months when using this formula?