Thread: [Solved] Formula to divide if no of days in month is 28
View Single Post
 
Old 06-25-2014, 08:29 AM
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
Hi
Quote:
if no of days in month is 28
In your formula you don't obtain this but the "weeknum". The appropiate function should be DAY() instead of WEEKNUM()
Reply With Quote