Posted inResources
Excel Tips: Calculating a Date Based on Year, Week Number and Day of the Week
Excel Tips: Calculating a Date Based on Year, Week Number and Day of the Week…
Posted inResources
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…
Posted inResources
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…
Posted inResources
Excel Tips: Selecting a random value from a List.
Excel Tips: Selecting a random value from a List. Using the RAND function in…