SOLVED

# Increment a date based on day of the month

Occasional Visitor

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

Thankyou very much for any assistance

2 Replies
best response confirmed by dannie_de_beer (Occasional Visitor)
Solution

# Re: Increment a date based on day of the month

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

# Re: Increment a date based on day of the month

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

In C2

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

and format the formula cell as Date.