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
-
Hi,
To get the first day of the current month you can use this formula:
=TODAY(1 - DAY(TODAY()))
Answers
-
Hi,
To get the first day of the current month you can use this formula:
=TODAY(1 - DAY(TODAY()))
-
@Etienne Mermillod that is great thank you
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!