LinkBack URL
About LinkBacks
Hi
Yes they relate to one person
Ther reason why the dates jump is that there is some historic data in the database which isnt in date order
Roger
Hi
Yes they relate to one person
Ther reason why the dates jump is that there is some historic data in the database which isnt in date order
Roger
Work in progress. Here's what I have so far...
=COUNTIF($A$5:A5,">"&TODAY()-365)&CHOOSE(AND(MOD(COUNTIF($A$5:A5,">"&TODAY()-365),100)<>{11,12,13})*MIN(4,MOD(COUNTIF($A$5:A5,">"&TODAY()-365),10))+1,"th","st","nd","rd","th")&" in 12"
B5 and copy down.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
Glenn
Looks good so far.
If it is more than a year ago a blank would be good
Id need to substitute today() to a cell which contains the date of the latest episode
R
Try this. I think I may be overcomplicating things....
I like complicated stuff!
I still need the stuff in post 10 which might overcomplicate it further
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks