Use the AND function to show sales for a specific period of time
As the article’s title suggests, we will be learning how to use the AND function to show sales for a specific time period. This formula will return TRUE when it finds a date within the range specified and FALSE when the date is not in the range.
How to show sales in a specific time period
- Select Cell B1 and enter the start date.
- Select Cell B2 and enter the end date.
- Enter your dates as shown below or apply to your worksheet accordingly.
- Column B holds the sales amount for the dates.
- Select Cell C5 and enter the following formula: =AND(A5>=$B$1,A5<=$B$2).
- Press Enter and use the fill handle to copy the formula down as required.
You can apply this concept to your worksheets accordingly. This will work in Excel 97, 2000, 2003 and 2007.
- How to check for future dates using TODAY Function in Excel
- How to use the NOW Function to show the current time in Excel
- Use the MIN function to find the employee with the lowest sales
- How to Use the RANK function to determine the rank of sales
- How to Use the MEDIAN function to calculate the median sales
