I need to repeat Sunday, Monday, etc. all through a worksheet in nonadjacent
cells. What is the formula that works for text and not date values?
I need to repeat Sunday, Monday, etc. all through a worksheet in nonadjacent
cells. What is the formula that works for text and not date values?
You could use this for the month of June, D1 is where you enter the day number.
=IF(OR(E1={1,8,15,22,29}),"Friday",IF(OR(D1={2,9,16,23,30}),"Saturday",IF(OR(E1={3,10,17,24}),"Sunday",IF(OR(E1={4,11,18,25}),"Monday",IF(OR(E1={5,12,19,26}),"Tuesday",IF(OR(E1={6,13,20,27}),"Wednesday",IF(OR(E1={7,14,21,28}),"Thursday","")))))))
Or
=VLOOKUP(D1,A1:B30,2,TRUE)
Place this formula in C1 and the day number goes in D1.
Column A1:A30 is the day number 1 through 30 and column B1:B30 is the week day Monday through Sunday.
I'm sure there's other ways better than this, but why would you not want to use a date function?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks