View previous topic :: View next topic |
Author |
Message |
john Site Admin
Joined: 16 Mar 2004 Posts: 3434
|
Posted: Mon Feb 07, 2005 10:57 am Post subject: Re: Usign Search to get a Table of Contents |
|
|
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 |
|
|
abacquer
Joined: 22 Mar 2004 Posts: 193
|
Posted: Wed Feb 01, 2006 12:43 pm Post subject: NOTE! |
|
|
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 |
|
|
Search all BlogHarbor support resources.
|
View previous topic :: View next topic |
|
|
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
|
|