Formula to calculate week of month completed

[bwlytkr]

I tried this formula in Access to calculate the week of the month the task was completed and it doesn't calculate correctly. Any thoughts on the formula I can use to do this. It's the standard 3/17/2020 date format.

Completed Week: Format([Completed Dt],"w""Week")

 

[bwlytkr]

Sorry, misunderstood the date part function. I'm not sure how to write this, =ISOWEEKNUM(A1)-ISOWEEKNUM(DATE(YEAR(A1),MONTH(A1),1))+1, in access. Can you help?

 

[bwlytkr]

Sorry, misunderstood the DatePart Function. I' don't know how to write this, =ISOWEEKNUM(A1)-ISOWEEKNUM(DATE(YEAR(A1),MONTH(A1),1))+1, in Access. I could use some help if you know.

 

[bwlytkr]

as info, I found a formula that works. Here it is in case someone else wants to use it.

Completed Week: DatePart("ww",[Completed Dt])-DatePart("ww",DateSerial(Year([Completed Dt]),Month([Completed Dt]),1))+1

 

[welshgasman]

That is the way. The logic is exactly the same as your formula in Excel.