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

FAQ

Thread Tools

Display Modes

06-25-2014, 07:06 AM

shilabrow

Windows Vista Formula to divide if no of days in month is 28

Office 2007

Advanced Beginner

Join Date: Apr 2014

Posts: 45

Formula to divide if no of days in month is 28

I am not getting this right - All Help appreciated.
I want to divide if no of days in month is 28 and if not then the other criteria.

=K6/if(weeknum(today())=28,(Month(today())*12,(MONTH(T ODAY())-1)*12). I think am suppose to reference the 28days in a different way but I am unsure and dont know how. Thanks for the help!!

Last edited by shilabrow; 06-25-2014 at 08:14 AM.

« Previous Thread | Next Thread »

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 10:35 PM.