I was surprised to find, on looking, that Quattro Pro’s extensive list of date and text forumlas don’t contain anything to convert a date to a weekday, like “Tuesday”.
Here’s the formula you’ll need do such a conversion:
To try the example, place a date in cell A2, and the formula in B2:
"Thursday","Friday","Saturday"))Some notes: that first blank selection is required, as the @CHOOSE function wants a "zero" case, but @WEEKDAY returns 1-7.You can, of course, abbreviate or translate the weekday names; just be careful to keep the quotes and commas matched up in sets.The @IF at the beginning, with the extra set of blank quotes, leaves the cell blank if the cell that should contain a date is empty.Jerry Stern
Moderator and Webmaster
Author of Graphcat and FileTiger