more than 64 level nesting

p45cal · #1 06-10-2023, 12:49 PM

In the attached cell AM1 contains your start date (which you can adjust).
Cell A3 contains a formula which uses AM1 to create the first date.
Then in cell A20 there is:

Code:

=IF(COUNTIF($A$3:$A19,$A3)>1,"Date: " & TEXT(DATE(RIGHT($A3,4),MID($A3,10,2),MID($A3,7,2))+1,"dd/mm/yyy"),$A3)

This can be copied to every 17th row as has been done in the attached.

stricky · #2 06-11-2023, 09:29 PM

Quote:

Originally Posted by p45cal

In the attached cell AM1 contains your start date (which you can adjust).
Cell A3 contains a formula which uses AM1 to create the first date.
Then in cell A20 there is:

Code:

=IF(COUNTIF($A$3:$A19,$A3)>1,"Date: " & TEXT(DATE(RIGHT($A3,4),MID($A3,10,2),MID($A3,7,2))+1,"dd/mm/yyy"),$A3)

This can be copied to every 17th row as has been done in the attached.

Sorry for replying from another id I lost password for that a/c (redirected_math)

thanks @p45cal your solution is on the right track for me. but it still doesnt use shift info from A4. i need to change date manually if needed in any of those cells.

say i started A3 at 01/06/23 shift A, then A20 will be 01/06/23 shift B, A37 02/06/23 shift A and so on. then suddenly at A88 (where is 08/06/23 shift B now) i manually to change it to 11/06/23 shift B. so next A105 will automatically be 12/06/23 shift A. how do i do that. your formula doesnt solve that

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
INDEX and MATCH nesting with if	Peter Simpson	Excel Programming	1	05-27-2019 06:53 AM
Nesting Merge Fields	LearningMom	Mail Merge	9	09-25-2017 01:44 PM
Automatic numbered lists - Cannot create new point at level 2, after making level 3 points.	icor1031	Word	1	01-14-2016 09:24 PM
Nesting and IF & AND statement	lynchbro	Excel	4	04-16-2015 11:39 AM
Nesting Variables SET, LISTNUM, and REF	Wyskers	Word	1	11-13-2011 05:43 AM