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
Help with Excel Logic Function?
I have a column of numbers from 1 to 15 and next to the column I want a day to appear depneding on the number, so if the number is 1, 6, 11 the day that would appear is Monday, if the number is 2, 7, 12, the day would be Tuesday etc. is there a function that can help me with this.
2 Answers
- Boots McGrawLv 51 decade agoFavorite Answer
I can think of one right off the top of my head. It's probably not the most efficient, but it's short, and it works. I assume Saturday and Sunday won't be used here?
Assume numbers are in column A, starting at row 1...
at cell B1, type:
=IF(MOD(A1,5)=1,"Monday", IF(MOD(A1,5)=2,"Tuesday",
IF(MOD(A1,5)=3,"Wednesday", IF(MOD(A1,5)=4,"Thursday", "Friday"))))
Copy and paste this formula down column B.
- 1 decade ago
If you are interested in converting the date to a weekday, then converting that weekday (number) to weekday (name) then you would do something like this:
in the first column, list of dates. In column 2 you would have:
=IF(WEEKDAY(A1)=1, "Monday", IF(WEEKDAY(A1)=2, "Tuesday", IF(WEEKDAY(A1)=3, "Wednesday", IF(WEEKDAY(A1)=4, "Thursday", IF(WEEKDAY(A1)=5, "Friday", IF(WEEKDAY(A1)=6, "Saturday", IF(WEEKDAY(A1)=7, "Sunday", "")))))))
