Day of Week instead of short date
Comments
-
This is long, but try:
=IF(WEEKDAY(Bid Date1) = 1, "Sunday", IF(WEEKDAY(Bid Date1) = 2, "Monday", IF(WEEKDAY(Bid Date1) = 3, "Tuesday", IF(WEEKDAY(Bid Date1) = 4, "Wednesday", IF(WEEKDAY(Bid Date1) = 5, "Thursday", IF(WEEKDAY(Bid Date1) = 6, "Friday", IF(WEEKDAY(Bid Date1) = 7, "Saturday")))))))
Put that formula in Day1 and then drag it down as needed.
-
Thanks Wade.
Unfortunately, this is what I got #Unparseable
-
Disregard Wade. I realized I needed brackets around [Bid Date]. Works Great!
-
radix ✭
I suggest another more clean way:
Create a new sheet let's say called "conversioni" with a conversion table like (sorry italian days...)
then in the data sheet you create a formula
=INDEX({CONVERSIONI: weekday}; MATCH(WEEKDAY([Creato il]@row); {CONVERSIONI: Weeknumber}; 0))
that point at that conversion table and transform your weekday in the word you chose
then you can create a column formula and that's all...
Help Article Resources
Categories
I guess you forget to use AND( ).<\/p>
For example, <\/p>
- IF([Total Value to User Score]@row = <3.8, >4.7, \"Mild,<\/li><\/ul>
should be<\/p>
- IF(AND(<\/strong>[Total Value to User Score]@row < 3.8, [Total Value to User Score]@row > 4.7)<\/strong>, \"Mild\",<\/li><\/ul>
However, the following would be more straightforward.<\/p>
- =IF([Total Value to User Score]@row >= 4.8, \"No Pain\", <\/li>
- IF([Total Value to User Score]@row >= 3.8, \"Mild\", <\/li>
- IF([Total Value to User Score]@row >= 2.8, \"Moderate\", <\/li>
- IF([Total Value to User Score]@row >= 1.8, \"Very Severe\", <\/li>
- IF([Total Value to User Score]@row < 1.8, \"Extreme\", \"//www.santa-greenland.com/community/discussion/22326/\")))))<\/li><\/ul>
- IF(AND(<\/strong>[Total Value to User Score]@row < 3.8, [Total Value to User Score]@row > 4.7)<\/strong>, \"Mild\",<\/li><\/ul>