How many days in a month excel vba

Posted: Pilot Date: 19.06.2017

Compare Excel Excel Templates DownloaderXL Pro. There are currently 1 users browsing this thread.

Forum New Posts Control Panel FAQ Calendar Forum Actions Mark Forums Read Quick Links Today's Posts Rules What's New? Forum HELP FORUMS Excel General VBA to calculate the number of days in a month based on ActiveSheet name.

Results 1 to 4 of 4.

how many days in a month excel vba

VBA to calculate the number of days in a month based on ActiveSheet name. Thread Tools Show Printable Version Search Thread.

Calculate the Number of Working Days in Each Month Using Excel

February 9th, 1. Join Date 2nd May Posts VBA to calculate the number of days in a month based on ActiveSheet name googletag. Hi All, I'm running a vba code in the active sheet on a workbook.

continue a "do while" loop in VBA/Excel

All sheet names are JAN, FEB, MAR and so on. What I need is a line of code to determine how many days are there in that month based on the name of the ActiveSheet. Below is the code. February 10th, 2.

Max View Profile View Forum Posts. Join Date 3rd November Location United States: Portland, OR Posts VBA to calculate the number of days in a month based on ActiveSheet name I didn't go through all of your code, but if you want to know how many days are in a month based off your active worksheet name you can use this: February 10th, 3.

how many days in a month excel vba

Smallman View Profile View Forum Posts Visit Homepage. Join Date 18th August Location Brisbane, Austalia Posts 3, VBA to calculate the number of days in a month based on ActiveSheet name Hi This should work for you. Works on the activesheet VB:.

February 10th, 4. Dear Smallman, Thank you for the above code.

DATE Formula Excel – How to use Excel DATE Function | Excel & VBA – Databison

Would it be possible to have the Year input by an input box? Dear Max, your code works correctly except for FEB where it calculates as Quick Navigation Excel General Top Site Areas Settings Private Messages Subscriptions Who's Online Search Forums: Thread Information Users Browsing this Thread There are currently 1 users browsing this thread. Possible Answers Excel - calculate the number of work days in an entire month By Lee Francis in forum Excel General.

Copy Data from one Worksheet to Another in Excel VBA

December 9th, , Calculate number of Days based on contract By NellyP in forum Excel General. February 4th, , Formula to calculate number of working days left in month By Jaffey in forum Excel General.

how many days in a month excel vba

September 3rd, , Calculate number of headcount per month based on start and end date By Keeto in forum Excel General. July 18th, , Formula to calculate the number of days till end of month By MilkymayZA in forum Excel General.

May 31st, , Bookmarks Bookmarks Digg del. Excel Trader package Code VBA googletag. The time now is Ozgrid is Not Associated With Microsoft. Ozgrid Retains the Rights to ALL Posts and Threads.

inserted by FC2 system