Function+Library

This page has a lot of functions for working with dates and working with databases (that fix the MATCH function)
==One very important function is the percent of time function that allows you to determine the percent of time a project is under construction, in service, under lease etc. It is very important for situations where you have a portfolio of projects.==



=Excel has the EOMONTH function and the EDATE function that allows you to efficiently work with dates. But it does not have functions that allow you to work with quarters and half-years. These functions that include EQQTR and EQHALFYR allow you to easily work with dates when you need to convert months to quarters etc.=





==This file has various functions that allow you to efficiently work with data bases. For example if you want to find the first characters of a field without looking for the whole field or if you want to find the second occurance of the field, alternative match functions are included.==