Save file with previous week number

[Niranjanrajrishi]

I am trying to save my dashboard report with previous week number. I tried with multiple ways but could not get it with month's week number.

Can I save a file with Previous Week number of Month with Month - Year like "Week 3 - Feb - 2018"

 

[vletm]

Niranjanrajrishi
There are many kind of weeks, here is one sample:

MsgBox "Week " & Format(Date - 7, "ww", vbMonday, vbFirstFourDays) & " - " & Format(Date - 7, "mmm - yyyy")

 

[Niranjanrajrishi]

Thank you.

I would require to save my workfile with previous week number of the month. let's say I want to save my file last week's number (Monday to Sunday) and it should be Week 4 - Feb - 2018.

Is your coding it says Week 7. I hope you have considered the week of the year. Can you help with the code to save the file as the requirement mentioned?

 

[vletm]

Niranjanrajrishi
You asked: I am trying to save my dashboard report with previous week number.
Did You ask what You wanted or something else?
For me, now is Week: 8, Day: 25, Month: April and Year: 2018.
My solution give week 7 and so on.
Hope? I know only possibilities.
As I tried to write
... There are many kind of weeks in the world.

 

[Niranjanrajrishi]

I get your point and the way your code gives the data.

I was trying to get the Week number of the month. I want to get only the Week number of Month. Let's say Feb'18 has 4 weeks and trying to save the dashboard of 3rd week of Feb'18.

Every Monday I need to save the Dashboard of the last week. If this does not work, I will go with your coding.

 

[vletm]

Niranjanrajrishi
You wrote something ...
Do You think same that You wrote?
You wrote that You would like to get something like: "Week 3 - Feb - 2018"
Now, You wrote I want to get only the Week number of Month.
What would that be?
For me, below is this February, 2018.
For me, there are five weeks - for You ... four?

Every Monday I need to save the Dashboard of the last week.
For me, next day will be Monday (26)
... You'll save week 8 file ...
or
What would Your term 'Week' mean?

Ps. One thing about Your filename ... is it useful?

 

[Niranjanrajrishi]

Thank you for the correction. Yes the week count is 5.

So If I want to save the file with with Week number 4, how would I adjust the coding?

Our week day ends on Friday; hence the file name should be "Week 4 - Feb - 2018.

Does it possible to save the file name? Sorry if I have not given the proper info before.

 

[vletm]

If this is so 'clear' for You ...
Would You know few months later - what is what?
Next Monday, You would save file with '20180219-20180225' (= from Monday to Sunday)
Then, You would know what would it mean.

 

[Niranjanrajrishi]

Your suggestion is seems to be fair one. Can you guide me to fave the file with last week like 20180219-20180225?

 

[vletm]

Like this:

d = Date - Weekday(Date, vbMonday)
MsgBox Format(d - 6, "yyyymmdd") & "-" & Format(d, "yyyymmdd")

 

[Niranjanrajrishi]

Thank you so much! It worked!