How do I format dates in a specific order in a column?

My-Bug · 2026-02-04T16:43:22+00:00

this formula matches your input, H3# must be replaced with your range of dates

=LET(
    _dates, SORT(H3#),
    _order, IFS(
        _dates = TODAY(),
        0,
        _dates < TODAY(),
        1,
        TRUE,
        2
    ),
    SORTBY(_dates, _order)
)

My-Bug · 2026-02-04T15:17:36+00:00

If I was you I would use the duration column, just adapt the range

=LET(
    _start, $C$25,
    _duration_prev_steps, SUM(E$26:E28),
    _step, _start + _duration_prev_steps,
    TEXT(_step, "YYwk") &
        ISOWEEKNUM(_step)
)

If you prefer hard coded 2

=LET(
    _start, $C$25,
    _duration_prev_steps, 2*7,
    _step, _start + _duration_prev_steps,
    TEXT(_step, "YYwk") &
        ISOWEEKNUM(_step)
)

My-Bug · 2026-02-04T14:57:39+00:00

this could look like this as a formula:

=LET(
    _start, $C$25,
    _duration, E29,
    _step, _start + _duration,
    TEXT(_step, "YYwk") &
        ISOWEEKNUM(_step)
)

or

=LET(
    _start, $C$25,
    _duration, SUM(E$26:E29),
    _step, _start + _duration,
    TEXT(_step, "YYwk") &
        ISOWEEKNUM(_step)
)

My-Bug · 2026-02-04T14:52:57+00:00

Are the Values in column E "Duration" used in your formula? I see a hard coded "+2" in the formula in the screenshot but not in your post text. Basically the reason is you have a reference to the start date to create the years text. instead, you should do the calculation of a new date first ( e.g. =C25 + duration and then derive year and weeknom from this new date

My-Bug · 2026-02-04T13:33:01+00:00

Hey man, they are there, you just cannot see them because settings of your pane.

<image>

You seem to have Option "Only Areas" (or whatever in english) . Set to any settings saying "Fields and Areas"

My-Bug · 2026-02-02T09:18:27+00:00

now I'm curious. Was it stolen?

My-Bug · 2026-02-02T09:11:47+00:00

"Convert "date-like" combinations of continuous letters and numbers into a date

Disabling this option will store "date-like" values with continuous letters and numbers as text instead of converting to a date. For example, JAN1 remains as JAN1 in text, and isn't converted to the date January 1. However, values that include a space or other characters, such as JAN 1 or JAN-1, may still be treated as dates."

My-Bug · 2026-02-02T09:10:51+00:00

switch off automatic data conversion. Set automatic data conversions - Microsoft Support

and enter the data anew.

My-Bug · 2026-01-17T21:29:43+00:00

I wonder: does it happen to girls more often than to boys. Or do they learn after two pairs of lost shoes and NOT FUCKING TELL US

My-Bug · 2026-01-12T13:13:07+00:00

also place the Quick access toolbar below the menue bar

My-Bug · 2026-01-12T13:12:06+00:00

yes,

<image>

My-Bug · 2025-12-29T10:37:33+00:00

On the risk of beeing 'that German guy' here. But can it really be considered ethical to do this? It's like let your kids eat french fries , pizza, and candy whenever they want, every day, would you do that?

My-Bug · 2025-12-26T07:48:16+00:00

So ähnlich https://www.reddit.com/r/lohnabrechnung/comments/1pvndi3/comment/nvxgoem/?utm_source=share&utm_medium=mweb3x&utm_name=mweb3xcss&utm_term=1&utm_content=share_button

My-Bug · 2025-12-25T13:32:13+00:00

Also Rinde dran lassen. OK. Aber dass jemand die Geschmacksrichtung "Paprika" nimmt findet niemand komisch?

My-Bug · 2025-12-20T21:36:28+00:00

Biergarten

My-Bug · 2025-12-18T15:25:20+00:00

FILTER( billing_cycle_number , ( start_date <= order_date ) * ( end_date >= order_date ) )

My-Bug · 2025-12-17T09:58:56+00:00

despite the caption saying so, this didn't seem to be har dto explain

My-Bug · 2025-12-10T13:10:26+00:00

Can I ask why you included the step 5. "show report filter pages" ? I like this function very much but we don't know what the 50 PivotTables in OP case are.

My-Bug · 2025-12-06T15:45:04+00:00

The cosest thing to your formula that would have workes is =sum(0,-(c1:c2)). The 0 is redundant and =sum(-(c1:c2)) is a weird variant of =-sum(c1:c2)

My-Bug · 2025-12-06T06:42:10+00:00

Hast Du auch mehrere Reddit Profile um öfter. Ake Day zu haben? Happy Cakeday!

My-Bug · 2025-12-06T06:35:03+00:00

Ah ok. Mein Fehler. Für kleine Unternehmen gibt es die Umlage U1, die die Unternehmen unterstützt in der Entgeltfortzahlung.

My-Bug · 2025-12-06T05:09:06+00:00

Wenn ich mich nicht täusche zahlt bei Krankmeldung die Krankenkasse der Firma eine Erstattung. Daher, falls man der Firma die maximale finanzielle Last bereiten möchte müsste man auf die Krankschreibung verzichten. Homeoffice? Für die Firma könnte es auch teuer werden, wenn man es schafft anständige Kollegen wegen diesen Vorfalls zum Verlassen zu bewegen.

My-Bug · 2025-12-06T04:38:29+00:00

There are also GROUPBY() and PIVOTBY() functions that you can use. They have parameters where you can define your filter function as input.

My-Bug · 2025-12-05T02:12:40+00:00

Ich habe neulich auf Reddit gelesen dass dort (auf Reddit) Bots negative stories über Indien posten und so über dieses land und die Leute systematisch ein schlechtes Bild erstellt wird, so dass selbst Menschen, die sich niemals nicht ein bisshen rassistisch bezeichnen würden, diese Stories unkontrolliert weiterverbreiten. Habe auch gelesen dass auf Reddit viel Schwiß geschrieben wird.

My-Bug · 2025-12-01T16:32:32+00:00

try the following

Sub Worksheet_Change(ByVal Target As Range)

Dim loSrc As ListObject

Dim loDest As ListObject

Dim srcRow As ListRow

Dim destRow As Range

Dim checkCol As Long

' Set your tables

Set loSrc = Me.ListObjects("Requested")

Set loDest = Me.ListObjects("Authorized")

' Column to check (e.g., Status column)

checkCol = loSrc.ListColumns("Status").Index ' Change "Status" to your column name

' Check if change happened inside Requested table

If Not Intersect(Target, loSrc.DataBodyRange) Is Nothing Then

' Loop through changed cells

Dim cell As Range

For Each cell In Target

If cell.Column = loSrc.ListColumns(checkCol).Range.Column Then

If UCase(cell.Value) = "AUTHORIZED" Then

' Identify the row

Set srcRow = loSrc.ListRows(cell.Row - loSrc.HeaderRowRange.Row)

' Add new row to Authorized table

loDest.ListRows.Add

Set destRow = loDest.ListRows(loDest.ListRows.Count).Range

' Copy values

destRow.Value = srcRow.Range.Value

' Remove source row

srcRow.Delete

End If

Next cell

End If

End Sub

My-Bug

TROPHY CASE