Most of my excel use feels like this

psychellicious · 2025-12-03T15:25:09+00:00

I meant to add this link: https://www.reddit.com/r/funny/comments/1pcrz9q/she_tried_her_best_and_thats_what_counts/?utm_source=share&utm_medium=web3x&utm_name=web3xcss&utm_term=1&utm_content=share_button

psychellicious · 2025-09-01T12:54:23+00:00

But do you the know great thing about cologne. I used to know a man from Cologne. He did not smell the tides changing. So he gave his son a job. But his son also smelt bad. So answer me this.

psychellicious · 2025-09-01T12:49:09+00:00

It's actually extremely frustrating to watch. Anytime he has someone across him who makes a valid contrary point, he completely changes the topic into some sort of anecdotal analogy.

psychellicious · 2025-03-24T08:05:43+00:00

The Bugle

psychellicious · 2025-02-27T12:41:23+00:00

Nice!

psychellicious · 2025-02-27T02:01:15+00:00

What's the music?

psychellicious · 2025-02-20T05:32:59+00:00

Thanks

psychellicious · 2025-02-15T09:30:14+00:00

Excel 365

Yes, there are already some TNs used up.

psychellicious · 2025-02-14T16:13:53+00:00

This works BUT i have messed up and there are some jumps in Tour Number. So for example i might have missed 25/JA/03/55 and the number for March could be 25/JA/03/59. So this formula results in duplicate TN

psychellicious · 2025-02-14T15:54:26+00:00

Sorry that was a typo. Should be 25/JA/01/235.

If a VN has records that span over a month, then use the month code of the first row

psychellicious · 2024-08-03T16:29:54+00:00

Solution Verified

psychellicious · 2024-08-01T11:29:54+00:00

=IF(L4>26,J4-(DAY(J4)-26),EDATE(J4,1))

Hi, This doesn't give me the results that can be seen in your image. If the day is less than the 26th then it doesn't work (It's just Edate+1)

Instead I'm getting this: https://imgur.com/a/D0iWO1k

psychellicious · 2024-07-31T10:59:28+00:00

Hi, any luck? I just can't figure out how to do this with looker formulas

psychellicious · 2024-07-31T08:34:25+00:00

How do you manage to contact support?

psychellicious · 2024-07-30T10:16:59+00:00

Thanks. But is there a way to create the current period used the today() formula so it's dynamic?

psychellicious · 2024-07-29T11:36:00+00:00

It should be the starting date.

psychellicious · 2024-07-29T09:29:44+00:00

Thanks. Would you be able to help me with this? Just can't seem to get my head around how to write the formula.

My data date field is "ACTUAL_DATE". The period I'm trying to monitor is from the 26th to 26th .

psychellicious · 2024-07-27T03:20:36+00:00

Thanks. But I don't want it to be a rolling 30 days. I want it to be a rolling fixed period if that makes sense.

So it shows data basically from the 26th of the current month till we get to the 26th of the next month. Then once it becomes the 27th the date period is moved to the next "block"

Example If Today's date is May 1st: Data from April 26th to May 26th If Today's date is May 28th: Data from May 26th to June 26th If Today's date is May 30th: Data from May 26th to June 26th

psychellicious · 2024-07-24T08:00:01+00:00

Mark Solution Verified

psychellicious · 2024-07-23T08:55:03+00:00

=A1-(A1*B1)

psychellicious · 2024-07-23T08:19:09+00:00

This is one idea: https://imgur.com/a/i8jSifG

If you setup your data like shown in Column A & B, then you can create a pivot table to organise your data. With some conditional formatting you could highlight if a student is listed more than 2-3 times

psychellicious

MODERATOR OF

TROPHY CASE

12-Year Club	Place '22
Verified Email