Brian W’s Profile

Community member since September 2018




I hope someone can help me.

Maybe I'm blind, but I can't find a way to make a Report for only yesterday,

I work on a big sheet (> 4,000 rows, 25 columns) with many different days in the column [Datum].

Now I want to make a report, that shows only the rows from yesterday. Not today, not


Good Day,

We are struggling with getting a "Years in service" calculator to work, after having pulled all the formulas that could be found by previous posts, still no luck.

=IF(AND(MONTH([Start Date]1) >= MONTH(TODAY()), DAY([Start Date]1) > DAY(TODAY())), YEAR(TODAY()) - 1 - YEAR([Start Date]1),


This is my formula:

=IF(AND([Scheduled Complete]6 < TODAY(), [Document Added]6 = 0, Complete6 = 0), 1, 0)

Not sure what i'm missing but as soon I check the box for document added it clears my flag. I don't want the flag to clear until all three criteria are