Work Experience and Age in years
For computing the duration of time intervals it is more convenient to use the undocumented function RASHAT(), the English version DATEDIF().
NETWORKDAYS(), the English version of NETWORKDAYS() returns the number of working days between two dates i.e. when counting holidays and weekends are not counted.
Objective function TODAY()the English version TODAY(), - to return the current date. Writing the formula =TODAY() get 21.05.2011 (unless of course today is the day).
Get the date range (start date, end date) in one cell in format 21-25.10.2012. br>
Find the number of days remaining until the end of the month.
Calculate the number of working days between two dates in case of non-standard work week: in
Count the number of months worked in the year. A month is considered as spent if the person worked there for more than 15 working days.
Write a formula to check the achievements of 20 years of age on today's date. The formula must return TRUE, if someone already has a full 20 years, otherwise the formula should return the value FALSE.
When planning the duration of performance of works are usually set in working days. The end date of the work can be calculated using the function WORKDAY().
Calculate the end date, if set to the period start date and period (time can be specified in days, months, years)
Determine how many full months have passed since a specific date until today (or until a specified end).
Determine how many years, months and days have passed since a certain date, and also solve the inverse problem.
Determine the age (or experience) in completed years.
If there is a need to perform calculations with dates prior to 01.01.1900, you will have to resort to some tricks to use built-in functions EXCEL for dates.
Calculate the insurance (labour) experience in years, months and days.
Determine how much a full (calendar) months have passed since the beginning of the year. If today 5/8/2009, since the beginning of the year, after 7 full months.