Forum Discussion
Solved
Increment a date based on day of the month
I need to increment a date with 1 day if the date is the first of the month. ie colum A has 2002/01/01 as a date. i want colum c to detect that it is the first of the month and then colum c m...
Hi dannie
In B2:
=If(DAY(A2)=1,A2+1,"")Date Date+1 01/01/2022 02/01/2022 02/01/2022 03/01/2022 04/01/2022 05/01/2022 01/02/2022 02/02/2022 02/02/2022 03/02/2022 04/02/2022 05/02/2022 06/02/2022 07/02/2022 28/02/2022 01/03/2022 02/03/2022 02/03/2022 03/03/2022 04/03/2022 05/03/2022 06/03/2022 07/03/2022 Regards, CarlosF
Assuming your date is in A2 then try this...
In C2
=IF(DAY(A2)=1,A2+1,"")and format the formula cell as Date.