Increment a date based on day of the month

[dannie_de_beer]

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 must reflect 2002/01/02

Thankyou very much for any assistance

[#2 · Accepted solution]

@dannie_de_beer 

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

[#3]

@dannie_de_beer 

Assuming your date is in A2 then try this...

In C2

=IF(DAY(A2)=1,A2+1,"")

and format the formula cell as Date.