Mar 20 2022 03:10 AM
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
Mar 20 2022 03:40 AM - edited Mar 20 2022 03:43 AM
Solution
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
Mar 20 2022 03:41 AM
Assuming your date is in A2 then try this...
In C2
=IF(DAY(A2)=1,A2+1,"")
and format the formula cell as Date.
Mar 20 2022 03:40 AM - edited Mar 20 2022 03:43 AM
Solution
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