Wow - that's amazing! Would love to know how on earth you work that out! Obviously I have a long way to go!
Maybe you will be able to help me with my other question...
I have dates in column D and then in the next column I have put the following formular to automatically calculate the number of days since that date. =TODAY()-D2
I then did CTRL + SHIFT + the down arrow, then CTRL + D to fill the entire column with the formula. However, I don't know how to make it not show up a number if there is no date in adjacent cell in column D.
Thanks in advance AGAIN if you can help - greatly appreciate it and very envious of you :)