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).
DATE(year, month, day) returns a serial number of a date based on the year, month and day values that you specify. When it comes to working with dates in Excel, DATE is the most essential function to understand. The point is that other Excel date functions not always can recognize dates entered in the text format.