Discussion Locked
Nesting of the Excel if and mod functions
0 helpful
0 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
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 (7x4=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.