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.
|