Sundance_Kid
Board Regular
- Joined
- Sep 2, 2017
- Messages
- 130
- Office Version
- 365
- Platform
- Windows
Hi, I am looking to figure out a formula that can basically restate a date to the 1st day of the month.
I use the format dd/mm/yyyy
So, if I have a file with multiple rows & dates on each row, what formula can restate the date to the 1st day of that month?
Below would be an example of dates to add a formula to restate them.
18/01/2022
22/12/2021
02/04/2021
Thanks
I use the format dd/mm/yyyy
So, if I have a file with multiple rows & dates on each row, what formula can restate the date to the 1st day of that month?
Below would be an example of dates to add a formula to restate them.
18/01/2022
22/12/2021
02/04/2021
Thanks