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

May 27, 2008

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

1

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

May 27, 2008

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, [...]

0

Finding the Last Day of a Given Month

May 27, 2008

=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

0

Selecting a random value from a List.

May 27, 2008

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).

0

Employee Engagement Requires the “Right Stuff”

May 20, 2008

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 [...]

0

Employee engagement

May 20, 2008

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 [...]

0

Incorporating Employee Engagement into the Business Strategy of Employee Retention

May 20, 2008

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 [...]

0

resignation Format

May 20, 2008
Tags:

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) [...]

2