lubridate parses dates by the order of their parts: mdy("03/14/2026"), dmy("14/03/2026"), ymd("2026-03-14"). Use the one that matches how the source writes them; the wrong one returns NA with a warning.
Subtracting two dates gives a difference in days; wrap it in as.numeric() to calculate with it. Use a fixed reference date in reports, such as the end of the month, so the numbers don't change every time the script runs.
floor_date(date, "month") rounds down to the first of the month, which is the right key for monthly totals. month(date) gives the month number and wday(date, label = TRUE) the weekday name. Both are useful labels, but they drop the year, so don't group by them across years.
Parse, measure days, round to the month and name the weekday.