Calculating a Date Based on Year, Week Number and Day of the Week

Use the DATE and WEEKDAY functions as shown in the following formula:
=DATE(C2,1,3)-WEEKDAY(DATE(C2,1,3),1)+7*(B2-1)+A2

Read Full Post »

Entering dates quickly, without having to use delimiters to separate month, day, and year.

nter only the \”day\” part of the date and complete it by using the DATE, YEAR, TODAY, and MONTH functions in the following formula:
=DATE(YEAR(TODAY()),MONTH(TODAY()),A2)
Thus, on entering \”5\”, the formula will automatically create a date representing the 5th of the current month in the current year.
Solution 2:
Enter the entire date, without delimiters, and use the DATEVALUE, [...]

Read Full Post »

Finding the Last Day of a Given Month

=DATE(YEAR(TODAY()),MONTH(TODAY())+num_mths,0) where num_mths = 0 for the end of month for the current month and num_mths = 1 for the end of the month for the next month, etc.
1. Tried the formula if num_months = 0, it gives the end date for the prev

Read Full Post »

Selecting a random value from a List.

Using the RAND function in the following formula:
=INDEX(A2:A7,ROUND(RAND()*COUNTA(A2:A7),0))
The value returned by the formula will change with each recalculation (F9).

Read Full Post »

Employee Engagement Requires the “Right Stuff”

Employee Engagement Requires the “Right Stuff”
By Theresa Welbourne
September 1, 2005: Years of research have led CIO Update columnist Theresa Welbourne of eePulse to one inescapable conclusion: we’re all just a little confused and we don’t know what to do about it.
For the last eight years, I have been involved in very frequent data collection from [...]

Read Full Post »

Employee engagement

Employee engagement
From Wikipedia, the free encyclopedia
Employee engagement is a concept that is generally viewed as managing discretionary effort, that is, when employees have choices, they will act in a way that furthers their organization’s interests. Engaged employees feel a strong emotional bond to the organization that employs them. (Robinson) This is associated with people demonstrating [...]

Read Full Post »

Incorporating Employee Engagement into the Business Strategy of Employee Retention

Incorporating Employee Engagement into the Business Strategy of Employee Retention
By Bill Erickson, Vice Chairman – Kenexa
Employee retention continues to remain a top priority at many organizations and one that companies increasingly view as a driver of business strategy. Business-critical knowledge can walk out the door when an employee leaves the company. While employee retention figures [...]

Read Full Post »

resignation Format

RESIGNATION:
From:
Name
Company name
Kolkata
February 29, 2008
TO WHOM IT MAY CONCERN
Subject: Letter of Resignation.
I, Mr. Name, would like to tender my resignation from my position in (company) on February 29, 2008.
I am making this decision due to certain unavoidable circumstances that have come my way.
I am truly indebted for the trust, confidence and unwavering support extended by (Company) [...]

Read Full Post »