0

Date Formula - Using < and cell reference

I need to reference all dates prior to today's date in a formula

I don't know how to create a formula to use within Jet that will be equivalent to ..$B$2 (where $B$2 is today's date). In other words, all dates up to today. I am using a formula to pull today's date =np("Eval","=Today()" - found in $B$2

Keep in mind the report goes out each day.

=NL("count","Contact",,"Last Call Date",?????,"Salesperson Code",$C8,"Contact Type","customer")

1 comment

Please sign in to leave a comment.