BlogHarbor Home Page
FAQFAQ  SearchSearch  MemberlistMemberlist  UsergroupsUsergroups  UsergroupsRSS   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 
Display ALL articles
Goto page Previous  1, 2 
Post new topic   Reply to topic    BlogHarbor Community Forum Index -> Tips and Tricks
View previous topic :: View next topic  
Author Message
john
Site Admin


Joined: 16 Mar 2004
Posts: 3434

PostPosted: Mon Feb 07, 2005 10:57 am    Post subject: Re: Usign Search to get a Table of Contents Reply with quote

Awesome article! Thanks for posting that. I never really learned how to do Excel formulas so it was useful to see those used towards something I would call practical...
Back to top
View user's profile Send private message Send e-mail Visit poster's website
abacquer



Joined: 22 Mar 2004
Posts: 193

PostPosted: Wed Feb 01, 2006 12:43 pm    Post subject: NOTE! Reply with quote

In 2005 BlogHarbor changed the way they format dates on the post manager view. Because of this change, Step #18 in my earlier article breaks (the formula will not work).

Replace the formula there with:

Code:
="<td valign=top><a href=""http://unbecominglevity.blogharbor.com/blog/_archives/" & MID(F1,12,4) & "/" & (((FIND(MID(F1,8,3),"JanFebMarAprMayJunJulAugSepOctNovDec")-1)/3)+1) & "/" & VALUE(MID(F1,5,2)) & "/" & D1 & ".html"" target=_BLANK>" & E1 & "</a></td>"


And everything should be happy again.
_________________
-- Abacquer, A.K.A. Chuck Seggelin
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Search all BlogHarbor support resources.
View previous topic :: View next topic  
Display posts from previous:   
Post new topic   Reply to topic    BlogHarbor Community Forum Index -> Tips and Tricks All times are GMT - 5 Hours
Goto page Previous  1, 2
Page 2 of 2

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum