Creating a formula

[mschneider331]

If anyone can help I appreciate it 

The range (un-named this time) A26: C67 is the database. The range (also un-named) E27:F28 will be used as the criteria range.
 In cell E28, enter a formula which will capture records in which the SaleDate field is on or after a date en-tered into cell F26.
 In cell F28, enter a formula which will capture records in which the SaleDate field is less than one month later than a date entered into cell F26.

[AlphaRaveNZ]

I replied to your other thread about the same issue before I realized that it was marked as solved. I'll add my response here in case your still looking for an answer:

Hi, I've assumed that by "capture records" you want a count of the appropriate values??? If my assumption is correct, then i've attached a solution for you to this message. If this isn't what you were looking for please clarify what you mean by "capture records". Thanks, hope this helps.
Tables.xlsx

[FDibbins]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

[FDibbins]

hmm also, this sounds very much like a homework assignment?