It can be whipped with electric beaters. For 1 cup (8 oz / 250 ml) evaporated milk, substitute 1 cup (8 oz / 250 ml) water plus 1 dry cup (4.5 oz / 125g) of powdered milk. Evaporated milk can be used as a substitute for cream in many recipes, helping to reduce the fat content in them.
In B2, enter the formula =TEXT(A2,dddd) to display the date as day-of-week, with the day entirely spelled out (Monday, for instance). Or, you can enter the formula =TEXT(A2,ddd) to display the date as day-of-week, with the day abbreviated to standard three-letter abbreviation (Mon, for instance).
Letâs take a look. This pivot table shows total sales by product. Letâs add the date field as a column, then group the date to show sales by year. When you first add a date field as a row or column label, Excel will break out the values by every value in the field.To group a date field, first select one of the dates.Then right-click and choose Group from the menu. Excel will display a grouping dialog box, with a list of date and time units.etâs add the date field as a column, then group the date to show sales by year. When you first add a date field as a row or column label, Excel will break out the values by every value in the field. To group a date field, first select one of the dates. Then right-click and choose Group from the menu.