SOLVED

Increment a date based on day of the month

Occasional Visitor

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

@dannie_de_beer 

 

Hi dannie

In B2:

 

 

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

 

 

DateDate+1
01/01/202202/01/2022
02/01/2022 
03/01/2022 
04/01/2022 
05/01/2022 
01/02/202202/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/202202/03/2022
02/03/2022 
03/03/2022 
04/03/2022 
05/03/2022 
06/03/2022 
07/03/2022 

 

Regards, CarlosF

@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.