Im looking for a formula to produce the date of the next upcoming first of the month

BriannaRocamora

If todays 7/10, then the next would be 8/1, if today is 8/1 then 9/1

NickStaffordPM

Hey Brianna, the following should do the trick, while may not be perfect.

=DATE(YEAR(TODAY()), MONTH(COLUMN WITH DATE), 1) + 30

Ensure the COLUMN WITH DATE is the 7/10 you referenced in your orginal question

Essentially you isolating the month from a date, making it the first of that month in date form, then adding 30 days to move the date forward a month…

Let me know if this worked!