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, 09:05 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

Thanks, Whatsup - Help still needed

=K6/if(day(today())=28,(Month(today()),(MONTH(TODAY())-1)*12)). when I use this I get error. I see your point though but I still need help in making the formula work.

« 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 12:30 AM.