fx="<="&B3 ??
It's typical when you want to use advanced filter or any of the D functions
where you normally use a header and this one looks to see if the date is in
past send or equal to the date in B3, so if for instance you have a list and
you want to sum all entries in one column where another columns with dates
and only sum those rows that have a date that is less than or equal to a
certain date like yesterday or today if the date in B3 is today but if the
date are tomorrow it won't be included
--
Regards,
Peo Sjoblom
"Daniel" wrote in message
...
Found this in formula entry box of cell B4
="<="&B3
B3 is date fomat
the cell B4 appears to be number
Looks like it change the B4 to be number format and equal or less than B3.
Why use the &?
Why use the "=<" ?
daniel
"Peo Sjoblom" wrote:
Looks like a criteria used for either countif, sumif, the D functions or
the
advanced filter
--
Regards,
Peo Sjoblom
"Daniel" wrote in message
...
Do you know what this mean?
I look at a worksheet and found this but not understand what is it?
Thanks
Daniel
|