codewala

code it

Google HTML5 plug-in for Internet Explorer 6, 7 & 8

By installing the “Google Chrome Frame” plugin for IE, the browser would be able to render pages which have been developed in HTML5.

The plugin can be installed from following link for IE

http://www.google.com/chromeframe

For testing purpose:

Visit this HTML5 website in IE browser before and after installing the plugin. (or any other html5 website)

http://cinema-series.orange.fr/evenement/universeries/en/

November 28, 2012 Posted by | HTML, Uncategorized | , , , | Leave a comment

Exclude weekends from planned dates in Excel

Learnt something new today while working with excel. Details are given below.

Task
To create a detailed project plan.

Problem
While working on creating project plan in excel had to constantly refer the calendar to avoid adding the weekend/holidays into the plan. Also this task become cumbersome when the plan gets changed/updated.

Solution
Use the in-build excel function WORKDAY

What do WORKDAY function do?
Use this function to calculate a past or future date based on a starting date and a specified number of days.
The function excludes weekends and holidays and can therefore be used to calculate end/delivery dates.

Syntax
=WORKDAY(StartDate,Days,Holidays)

Note
For the WORKDAY function to work, the “Analysis ToolPak” add-in needs to be installed and should be active. To activate the add-in, go to Developer tab –> click on the “Add-ins” button –> tick the “Analysis ToolPak” checkbox –> click ok.

July 30, 2012 Posted by | Excel, VBA | , | Leave a comment