Date Formula for the First of Every Month

Tony Barthelemy

Is their Formula I can apply for the Date to be the First of Every Month, because not all months have 30 days. Some have 31, like July? For example:

04/01/20

05/01/20

06/01/20

07/01/20

My current Formula which does not work for the Month of July

=Date3 + 30

Thanks

Paul Newcome

Try something like this...

=IFERROR(DATE(YEAR(Date3), MONTH(Date3) + 1, 1), DATE(YEAR(Date3) + 1, 1, 1))

Tony Barthelemy

Error: Circular Reference

Paul Newcome

I just used the cell reference you provided in your post. Are you trying to reference the date above to produce the first of the next month?