Date Formula for the First of Every Month
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
Answers

Try something like this...
=IFERROR(DATE(YEAR(Date3), MONTH(Date3) + 1, 1), DATE(YEAR(Date3) + 1, 1, 1))

Error: Circular Reference

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?
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!