Setting a date column to the 1st of the Month


I am collecting data for a report and the data i want to show is to include everything from the previous month. At the minute i manually change a date column to the 1st of the current month so that it filters out everything that has been added this month.

I have found this formula =MONTH(TODAY()) + "/" + 1 + "/" + YEAR(TODAY()) but as i am in the UK this returns the date in the US format and my data is not correct.

Is there a way to change the formula so that the date returned is in the UK format (DD/MM/YY)

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!