Simple Microsoft Excel formula to find the last day of any given month.
' =DATE(YEAR(A1),MONTH(A1)+1,0) '
Posts Related to Find the Last Day of any Month
How to create Excel function/formula?
This is the reason why the power of Excel when combined with VBA is almost limitless. When we can’t found any Excel function that suite ...
Excel VBA Add Set of Worksheets Automatically
There is a time when we must create a set of Excel Worksheets templates on a regular basis in our work. For example, a set ...
Changing Microsoft Excel Status Bar
Maybe for some reason we want to change our Microsoft Excel Status Bar, then this simple vba function will do the work for us. The ...
Number of Cells/Rows/Columns With Formula
A few weeks ago I received this question from someone called LS: Hi I want to write a macro that counts the following - Number ...
Handy VBA To Calculate Person Age
This handy VBA procedure is just to show you how we can calculate and display someone Age. To do this, of course we need to ...
Thanks.
If the Day Number is over End of Month, It will go to nex month
DATE(2008,1,35) returns the serial number representing February 4, 2008.
hi hwsris, that is why we use 0 in the Day number, to make sure that we will have the last day of the month.
Pingback: Prestashop Templates
Pingback: debt consolidation companies
Pingback: reverse mortgage brokers
Pingback: sonic producer
Pingback: sexe gratuit