After Hours

General discussion


Nesting of the Excel if and mod functions

By ripneagle ·
Tags: Off Topic
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.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Related Discussions

Related Forums