Thread: [Solved] Formula to divide if no of days in month is 28
View Single Post
 
Old 06-25-2014, 03:24 PM
whatsup whatsup is offline Windows 7 64bit Office 2010 32bit
Competent Performer
  
Join Date: May 2014
Posts: 137
whatsup will become famous soon enough
Default
Check on the parentheses, there is something wrong, excel doesn't allow to enter the formular, but gives you some idea where to look.

Maybe that will work for you, but make sure that it meets your requirement:
=K6/IF(DAY(TODAY())=28,MONTH(TODAY()),(MONTH(TODAY())-1)*12)
Reply With Quote