days passed for current month google sheets code example

Example 1: Google Sheets How to Count the Days Between Two Dates

# Basic syntax:
=DAYS("end_date", "start_date")

# Example:
=DAYS("01/01/2019","01/01/2018")

# Note, use =NETWORKDAYS for business days

Example 2: first day of the month google sheets

=EOMONTH(TODAY(),-1)+1