Bonjour,
Un peu de Power Query pour gérer la chose !?
Pour les dates :
let
Source = Excel.CurrentWorkbook(){[Name="Data"]}[Content],
Types = Table.TransformColumnTypes(Source,{{"Date", type date}, {"A", Int64.Type}, {"B", Int64.Type}, {"C", type number}, {"D", Int64.Type}}),
Weeks = Table.AddColumn(Types, "Semaine", each if Date.IsInPreviousWeek([Date]) then "J-7" else "Autre"),
Months = Table.AddColumn(Weeks, "6 mois", each if Date.IsInPreviousNMonths([Date],6) then "6 mois" else "Autre")
in
Months
Cdlt.