Formula to divide if no of days in month is 28

		Microsoft Office Forums > Microsoft Excel > Excel
Formula to divide if no of days in month is 28

06-25-2014, 08:29 AM

whatsup

Windows 7 64bit Formula to divide if no of days in month is 28

Office 2010 32bit

Competent Performer

Join Date: May 2014

Posts: 137

Quote:

if no of days in month is 28

In your formula you don't obtain this but the "weeknum". The appropiate function should be DAY() instead of WEEKNUM()

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel Formula Showing Revenue Recognition Based on Days and Months	stratcat	Excel	4	03-16-2014 10:09 AM
Formula To Calculate Countdown Days To Project Completion	Catherine	Project	1	02-19-2014 11:15 AM
Formula for week days only	gbaker	Excel	5	02-15-2014 01:07 AM
Formula to count entries as per month, year and submission wise from different sheets	pinkacidpunk	Excel	1	05-28-2013 08:26 AM
formula divide by serio error	vthomeschoolmom	Excel	1	04-18-2012 02:29 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:58 AM.