Excel Tips: Calculating a Date Based on Year, Week Number and Day of the Week Use the DATE and WEEKDAY functions as shown in…
Excel Tips: Entering dates quickly, without having to use delimiters to separate month, day, and year.
Excel Tips: Entering dates quickly, without having to use delimiters to separate month, day, and year. Solution 1: Enter only the \”day\” part of the…
Excel tips: Finding the Last Day of a Given Month
Excel tips: Finding the Last Day of a Given Month =DATE(YEAR(TODAY()),MONTH(TODAY())+num_mths,0) where num_mths = 0 for the end of month for the current month and…
Excel Tips: Selecting a random value from a List.
Excel Tips: Selecting a random value from a List. Using the RAND function in the following formula: =INDEX(A2:A7,ROUND(RAND()*COUNTA(A2:A7),0)) The value returned by the formula…