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.

0 replies

No replies were posted before this discussion closed.

This discussion is closed to new replies.