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).
Compare Dates and Times. This example teaches you how to compare dates and times in Excel VBA. Dates and times are stored as numbers in Excel and count the number of days since January 0, 1900. What you see depends on the number format.1. Enter some numbers in column A. 2. These numbers are dates. This is a perfect way to enter some dates without worrying about the Date format. Change the format to Date (Right click on the column A header, Format Cells and choose Date).Result: Note: Dates are in US Format.Months first, Days Second.hat you see depends on the number format. 1. Enter some numbers in column A. 2. These numbers are dates. This is a perfect way to enter some dates without worrying about the Date format. Change the format to Date (Right click on the column A header, Format Cells and choose Date).