|
|
#3
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) 
|
|
|
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 |
Windows 10 
Office 2021
Threaded Mode