Automatically Insert Number of Days in Specific Month

March 4, 2009 by vba excel
Filed under: Excel Formulas 
Sponsor

Excel Formulas Question:

I want to know whether it is possible to set up a formula that would automatically insert the number of days in the current, previous month or specific month. Currently I am having to manually insert the number into the formula which is takes longer time, an axample below, month is where I want the number inserting:
=SUM(D61*37.5)/7.5*month

Excel Formulas Answer:

For the current month:
=DAY(EOMONTH(NOW(),0))

For the previous month:
=DAY(EOMONTH(NOW(),-1))

These require the Analysis ToolPak add-in be installed. If you dont have microsoft excel Analysis ToolPak add-in, try this :

=DAY(DATE(YEAR(TODAY()),MONTH(TODAY())+1,0))

  • Digg
  • Sphinn
  • del.icio.us
  • Facebook
  • Google
  • E-mail this story to a friend!
  • Live
  • MisterWong
  • Propeller
  • StumbleUpon
  • Technorati
  • TwitThis
  • YahooMyWeb
  • Print this article!

Rate This Tips:

1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading ... Loading ...


Incoming excel search terms

insert month in excel,days in month excel,,days in a month excel,number of days in a month excel,excel days in month,how to insert month in excel,current month in excel,excel insert automatic number of days in month,excel number of days in a month,inserting each day of the month in excel cell,microsoft excel insert months automatically,microsoft excel turning number of days into years/months,mss,vba days in month,auto add worksheet days in month,auto insert date in excel,auto number of days each month excel,automatically change month and year in excel,average on number of days in excel,days of the month excel,excel fill column with days of month,excel formula automatically updated each day,excel formula days in month,excel insert days of month,excel insert month,excel inserting current month automatically,excel list days in a month,excel macro number of days in month,how do i automatically add days of the week months of the year in excel,how do you get excell to automatically add the day,how to auto insert number in spreadsheet,how to insert current month dates in excel 09,how to insert dates automatically in excel,how to insert days of the month into excel,insert current month in excel,insert formula auto number in vba excel,insert numbers to excel spreadsheet,inserting months in excel,microsoft excel insert numbers,print days of the month in excel,specific month excel,vba excel number days month,xls number of days in a month,auto insert days of the month,=current month tag excel,add days to a month in excel,add month tabs to excel,add months automatically in excel,add months in excel



Related Excel Tips

Tags: , , , , ,

Comments

Have another excel answer or questions for this problem ?
Feel free to post it here..