Forum Discussion
rounding up days formula
This is a somewhat intriguing question. I note you've had almost 50 views and no replies. I suspect that might be due to the fact that it's not altogether clear what you're actually wanting to do (nor is it clear what the purpose is, which would be helpful to know, since there might be some other way to get from point A to point B)
Are we to understand that you want to take a value of 392 (representing a number of days) and convert that to a single text string (in a singe Excel cell) that reads "13mth 0wk 1 day"? Or could it be three separate cells, with 13, 0, 1 respectively in the three cells?
Now, since that's NOT in fact, what most of us would think 392 days equate to, is it possible for you to tell us what the bigger context is here, in addition to being a bit more descriptive on what the desired output is?