View Single Post
 
Old 06-10-2023, 12:49 PM
p45cal's Avatar
p45cal p45cal is online now Windows 10 Office 2021
Expert
 
Join Date: Apr 2014
Posts: 871
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default

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.
Attached Files
File Type: xlsx msofficeforums50953sample 1.xlsx (160.0 KB, 2 views)
Reply With Quote