Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
Promoted
Counting 1 of a number in Excel? How would I get it to count days on a project, either by fraction (1/30 days) or (1 of 30 days) etc?
1 Answer
Relevance
- expletive_xomLv 74 years ago
if A1 has 1 and B1 has 30 then you would use the CONCATENATE() function (shortened by the & symbol)
=A1&"/"&B1&" days"
but i get the feeling thats to easy....you would need to give a sample of what cells you are using and what is in the cells.
Still have questions? Get your answers by asking now.