WordPerfect Photo Album Catalogs & Clip Art

published by Science Translations

November 19th, 2006 at 7:29 pm

Day of the week display formula for Quattro Pro

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:

@IF(A2<1," ",@CHOOSE(@WEEKDAY(A2), " ","Sunday","Monday","Tuesday","Wednesday", "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 http://www.startupware.com