D
Daniel
Do you know what this mean?
I look at a worksheet and found this but not understand what is it?
Thanks
Daniel
I look at a worksheet and found this but not understand what is it?
Thanks
Daniel
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
P
Peo Sjoblom
Looks like a criteria used for either countif, sumif, the D functions or the
advanced filter
--
Regards,
Peo Sjoblom
advanced filter
--
Regards,
Peo Sjoblom
D
Daniel
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
="<="&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
P
Peo Sjoblom
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
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