Can a IF and Mod function be nested to create a formula that will figure out how many weeks in a month and also show the remainder of the product. Example: April has 30 days and when divided by 7 the product is 4 (7×4=28)and still there are 2 days left but excel shows a decimal of 4.29 as the product or answer. I would excel to show 4 wks, 2 days. I am using MS Excel 2003. Can someone help? Please. Thanks in advance.
