I spoke a little too soon, on this @Darren_Murphy . What I want to be able to do is use the week number column as the “now” so that it is confirming for me that the week number calculated by Weeknum(now) corresponds to the date of this week. How would I modify your formula to do that? My attempts …

[image] BLA_68: So I have a variable (“X”) that increments the week number up or down: Does that start at zero for now, or are you calculating the actual week number of the year based on the current date? If I’m understanding your use case correctly, I think I’d be more inclined to work with…

So you have a table where you store logs of something, and you want to confirm if the logs are falling into “this week” or not?

[image] BLA_68: What I want to be able to do is use the week number column as the “now” so that it is confirming for me that the week number calculated by Weeknum(now) corresponds to the date of this week. um, if that’s the case why not just do Weeknum(Now), and then do a direct comparison? …

@ThinhDinh , yes basically. And fair point @Darren_Murphy …I’m realizing that I didn’t totally explain the set up in the first post. So I have a variable (“X”) that increments the week number up or down: Weeknum(Now)+X. As I or other admins click the button, I want it to confirm the week using th…

I see your thinking. But the dates of the documents may be one of seven dates within a given week and I’m trying to group documents by week. So in Table 1, I was using WeekNum(date) to see first which week the documents were created in. And then in Table 2 I have a column “whichWeek” which is the m…

You can calculate the first day of the current week… then you will get all the first days using Darren’s suggestion… this technique is better because it will give you all years… not just the current one.

I agree with the others here… get the current date and subtract the day of week to get a consistent value for the first day of the current week.

That will push him back to the previous week :wink: You must adjust it by 1… if your week starts on Monday. (now-weekday(now-1))+1 Then add adjustment for the week you need x 7

Week Number math issue

Ask for Help

BLA_68 June 6, 2023, 3:38am 8

Oh I see. Ok. Now that I get it, I like that approach. Thanks @Darren_Murphy and @Structure_Art_DIGITA.

Topic		Replies	Views
Convert WeekNum to "Week of XYZ" Ask for Help	3	9859	June 3, 2023
📅 MORE Date Math incl. Weeknum! Ask for Help	14	1646	January 22, 2021
Is there an easy way to sort by week number? Ask for Help	7	562	October 6, 2023
Numero semana Ask for Help	11	62	August 13, 2024
Grouping list items by week Ask for Help	10	440	December 13, 2022

Week Number math issue

Related topics