Posts Tagged ‘Date’


There are numerous Project Management tools available in the market which make life easier while managing huge projects. But for simpler projects, you don’t need all that jazz, just a simple project plan template is all that is required. Well, you can use conditional formatting to create simple Gantt Charts. Here’s how:

Step 1: Create your list of tasks and the decide the proposed dates against them. On the top row, put down the dates (one in each column) like this:

Task List

Task List

(more…)

Advertisements

IsDate() Function : VBA

Posted: June 3, 2013 by Theodoulus in Excel, VBA
Tags: , ,

This function returns TRUE if argument’s data type is Date otherwise it returns FALSEHowever, there is an exception. In case the argument type is String the result depends on the contents of the string. If string is in a recognisable date (or time) format then the function returns TRUE.

One could say that the name of the function is misleading since it checks not just for date but time as well.

The Syntax for the function is:            IsDate(expression) 

Examples:

---------It accepts Date and Time in many formats------------------------ 
IsDate(#01/31/2013#)             'Returns True, as argument is of Date Type
IsDate(#jan-2013#)               'Returns True,as argument is of Date Type
Isdate("January,2013")           'Returns True, as String is in date format 
Isdate(10/15)                    'Return False, It treats it as a double value 
ISDate("10.15")                  'Returns True 
ISDate("10:15")                  'Returns True 
ISDate("10:15 AM")               'Returns True
ISDate("10:15:12")               'Returns True

Working with dates and times in Excel is a tricky business. If you don’t know how Excel stores dates and times and if you add them, you might end up getting unexpected results. e.g.

Apparently Wrong Result

Apparently Wrong Result

At the surface of it, it looks like the addition is giving a wrong result. In reality, however, Continue Reading