RSS Feed
Twitter
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
Archive for May, 2008
Calculating a Date Based on Year, Week Number and Day of the Week
Posted by Mahmud Hasan on May 27th, 2008
Posted in 
Entering dates quickly, without having to use delimiters to separate month, day, and year.
Posted by Mahmud Hasan on May 27th, 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, [...]
Finding the Last Day of a Given Month
Posted by Mahmud Hasan on May 27th, 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
Selecting a random value from a List.
Posted by Mahmud Hasan on May 27th, 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).
Employee Engagement Requires the “Right Stuff”
Posted by Mahmud Hasan on May 20th, 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 [...]
Employee engagement
Posted by Mahmud Hasan on May 20th, 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 [...]
Tags: Incorporating Employee Engagement into the Business Strategy of Employee Retention
Posted by Mahmud Hasan on May 20th, 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 [...]
resignation Format
Posted by Mahmud Hasan on May 20th, 2008
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) [...]
