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).
2. To add a number of years, months and/or days, use the DATE function. Note: the DATE function accepts three arguments: year, month and day. Excel knows that 6 + 2 = 8 = August has 31 days and rolls over to the next month (23 August + 9 days = 1 September).o enter a date in Excel, use the / or - characters. To enter a time, use the : (colon). You can also enter a date and a time in one cell. Note: Dates are in US Format. Months first, Days second.