How to Change Text Like YYYYMMDD into YYYY/MM/DD format?

Often, you get text like 19950607 and you want to be able to convert it into text like 1995/06/07.  Here’s a formula you can use to convert the text into

a formula. (this assumes the text is in A1)

=DATE(MID(A1,1,4), MID(A1,5,2), MID(A1,7,2))

What this does is this:

Date formula has the following parameters – DATE (Year, Month, Day)

The formula I wrote about simply splits the text

into Year, Month and Day and uses it in the DATE function.

MID function allows you to split text and pick up parts of it. Here’s the syntax

MID(text, start number of digit you want to start from, number of digits)

MID(A1,7,2) – picks up the text 19950607 (i.e. A1) starts from 7 i.e. 0 and gives you two digits from there – 07

—————————————-

Excel/Financial ModelingProfitability/Cost AnalysisDashboard ReportingCustom Invoice

Free ebook: Landing Page Optimization Check List

As we promised earlier we  are launching

our second ebook!

Our ebook Landing Page Optimization Check List is

now available for download. We talk about various strategies that you need to keep in mind before churning out a landing page for your site.

Download: Landing Page Optimization Check List

We hope you enjoy it. You can also share this book on Twitter with your friends!

Managing Your Daily Tasks

Let me ask you a question. How often has any of the following thoughts occurred to you?

“I seriously don’t have enough time!”

“Oh no, how could I forget that task?”

“How am I expected to manage SO many things at once?”

Roughly, atleast once a day huh? It used to happen to me, too. Being a part of a small business means that you will naturally have a hundred things on your mind. And when you can’t manage all your tasks and responsibilities, it’s guaranteed chaos.

So it was only recently that I discovered the value of a little something called ‘To-Do lists.’ It’s a simple enough concept, (and quite an obvious one, if you think about it) but so often, most of us fail to do it.

All you need to do is spend some time, as soon as you come to work/school (that’s right –  do not check email the first thing in the morning!) to think

about your day/week ahead. Trust me, you will realize soon enough that those 15 minutes are not a waste of time!

Use some  trusted system to jot down your notes and lists – something that you will keep looking at an ongoing basis. This way, you do not need to bother about losing out on doing any important tasks, because you will keep going back to that system regularly. A pencil and scratchpad would do just fine, as long as you’re comfortable with it. (P.S: I recently started using Microsoft’s One Note and I’ve become a huge fan ever since). This way you can also link it to your calendar to mark tasks that need to be delivered by a particular time. Tip: Use that system to also jot down ideas that occur to you while you are working.

Always write down ‘actionable items’ in your list. For instance lets say your task for the day is to “Finish project X”. What would be the first thing you would do to finish Project X that day? Call Bob? Go to Google? Run down to the library for a reference book? Whatever it is, write that Step 1 down. Makes your job a whole lot organized.

Do you have any special tips to manage your daily

routine? Do let us know!

How to Plan a Business Trip – Part II

I wrote a post sometime back on how to plan a business trip. I had mentioned in passing that I would soon be writing a post that dealt with how to plan various events to attend during the

course of the trip. So how do you really go places(excuse the mild pun) during a business trip?

1. Have a clear objective as to what are the type of people you need to be meeting with.  Depending on that you need to choose your target locations and events.These can be networking events, seminars, conferences, referral meetings, unconferences, informal meetups, etc.

2. Plan in advance. Search for events in the cities which you are going to be visting. Some good resources include Meetup, Eventbrite, Upcoming, LinkedIn Events, Gary’s Guide, etc. From our personal experience, I would

definitely recommend Meetup. It’s an excellent resource.

3. When you send out your RSVPs, try to coordinate with the organizers of the event beforehand. This can be handy if you wish to make a presentation or a talk at a networking event, for instance.

4. Make sure you have just the right number of events lined up for a day. Time is a valuable resource when you are on a trip, but you don’t want to wear yourself out either. Also, you need to plan it right in order to meet up with existing clients, because hey, they are as much important(if not more) as prospects!

5. Lastly, a few pointers – give out business cards, be on time, be polite and listen to what others say. Request for 1-1 meetings and follow up with people.

Check out Chaitanya’s post on OpenForum to know more about how to make networking and referral events work for you. Do you have any interesting pointers from your own business trip experiences? Let us know!