Well if you add 1000 days to 00/00/1900 you get 26/09/1902, so it's got something to do with that.........what that is.......your guess is as good as mine.
Hi @akay47,
Welcome to the forum, take a look at this previous question, it may help
http://chandoo.org/forum/threads/rank-changing-the-sequens-of-duplicate-values.24731/#post-148676
Hi,
Can you post a sample so that someone can help you find"DP" and its associated 7 characters?
http://chandoo.org/forum/threads/posting-a-sample-workbook.451/#post-73705
This should work
=IF(AND(G$2>=$C3,G$2<=IF(LEN($D3)=0,TODAY(),$D3)),1,0)
Copy across and down
Alternative
=IF(AND(G$2>=$C3,G$2<=IF($D3="",TODAY(),$D3)),1,0)