I think that this could help. =DATE(2023, 6, 21) - returns a serial number corresponding to 21-June-2023. =DATE(YEAR(TODAY()), MONTH(TODAY()), 1) - returns the first day of the current year and month. =DATE(2015, 5, 20)-5 - subtracts 5 days from May 20, 2015. For additionally you can visit here.
... View more