Although Excel functions offers cover a wide spectrum, such as =SUM( ), = AVERAGE, =VLOOKUP( ), =DCOUNTA( ) and so on, there are often occasions where even after nesting one or more Excel functions within each other when it is not possible or very inconvenient to achieve the desired outcome.
We can create custom functions (just like any of the above) to perform whatever calculation you desire that relate to your daily business! Custom functions allow you to improve Excel! By having a custom function made according to your specification, you add power to Excel and save time.
Download this Excel demonstration
which contains the simple but powerfull custom function =DAYW( ).
=DAYW() function: - What Day of the Week
Is It?
A simple common requirement is to derive the day of the week (Monday, Tuesday,
etc) corresponding to a date. All Excel offers is the =WEEKDAY( ) function
which merely returns the day number! So for example, =WEEKDAY(TODAY( )) would
return 5 for Thursday – not very user-friendly! Although this can be
converted by nesting within a CHOOSE( ) function or used in conjunction with
a VLOOKUP( ) utilising weekday arguments, it would be far better if a function
was available to fulfil this most basic requirement!
- click here! You can tell a good software developer by the company it keeps!