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).
If you only want to display a date with the year and month, you can simply apply the custom number format yyyymm to the date(s). This will cause Excel to display the year and month together, but will not change the underlying date. Related functions. Excel TEXT Function.