Solved what is the formula to find what are due on a particular day

December 20, 2012 at 05:19:33
Specs: Windows 7
i have a set of reports that has to be delivered everyday. In excel if i put a particular date i need to see the set of reports due for that particular date. what could be the formula for this

See More: what is the formula to find what are due on a particular day

Report •


#1
December 20, 2012 at 11:49:10
You can set a filter to see specific dates.

That's just a guess. you'd need to provide more information to get a better answer, e.g. show us the list of reports and the dates they are due.


Report •

#2
December 20, 2012 at 12:02:26
✔ Best Answer
You could use Conditional Formatting to highlight cells based on a date entered in another cell.

For example, if you had report names in Column A and dates in Column B, like shown below, you could enter a date in C2 and both the Report Name and Date would be highlighted.:

          A            B             C
1   Report Name     Due Date    Date Request
2     Report A     11/22/2012    11/22/2012
3     Report B     11/23/2012	
4     Report C     11/24/2012	
5     Report D     11/22/2012	
6     Report E     11/23/2012	
7     Report F     11/24/2012	

1 - Select A2:B7
2 - Use this Conditional Formatting rule and choose a fill color

=$B2=$C$2

Note: The placement of the $ are based on the example shown so that the CF will be applied to entire range correctly.

When you enter a date in C2, the Report Name next to the Date that matches C2 will be formatted with your fill color. The Due Date will also be highlighted.

If you are looking to extract a list of reports due to another location, it is a bit more complicated and we would need to know a little about your data layout, like the example I posted above.

Please click on the following line and read the instructions found via that link before posting your data.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

Related Solutions


Ask Question