View Single Post
 
Old 06-25-2014, 07:06 AM
shilabrow shilabrow is offline Windows Vista Office 2007
Advanced Beginner
 
Join Date: Apr 2014
Posts: 45
shilabrow is on a distinguished road
Default 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.
Reply With Quote