date formula referencing specific date cell
I am working in a date column that has the Effective Date: 05/13/2019.
I want the Project Kick-off Date to reference the Effective Date - What formula do I enter so that:
(i) the Year is always the year listed in the effective date cell,
(ii) month is always January, and
(iii) Day is always 01?
I have tried this formula =DATE(YEAR([Date Value]7), MONTH(1), DAY(1)) but it returns 'invalid data type'.
Help Article Resources
Check out the Formula Handbook template!