Select the cell with the first date Then select the range of cells you want to fill Select Home >Nov 12, 17Since that Excel cannot recognize the date formats and just interprets them as a text string So you need to use DATAVALUE function and let Excel think that it is a Date value For example DATEVALUE ("11/3/18") Now we can write down the following IF formula with DatesNov 28, 13looking for something similar, I have a start and end date, and three Quarters in different columns I want the formula to check whether the date range is within the quarter, and if, so, to count the number of days that fall into that quarter Then I was hoping to replicate that across the three columns and just change the date
Range Lookup In Excel Formulas Excel Excel Formula Learning
Date range in excel pivot table