First impression on unpacking the Q702 test unit was the solid feel and clean, minimalist styling.
How many days in the month?
- — 12 January, 1999 21:49
Excel lacks a function for calculating the number of days in a particular month, so you'll need to construct your own formula. If cell A1 contains a date, this formula will return the number of days in the month:
1-2-3's @dateinfo function is more helpful. The second argument for this function determines the type of information to return about a date (oddly enough, "7" yields the number of days in the month). This formula refers to a date in cell A1: