1

Topic: How to calculate date of Monday under number of week?

Initially I calculate number of week and the last two digits of year:
Format ([Date]; "ww") and Format ([Date]; "yy")
I receive result in a format (on an example of the first week 2018):
118
Question. How to me to calculate date of the first day of week (in my case, Monday) having only 118?
Thanks.

2

Re: How to calculate date of Monday under number of week?

aoiu wrote:

having only 118?

Well year nevertheless is necessary... And with the registration of that in a year of 52 weeks, number 118 looks doubtful...

3

Re: How to calculate date of Monday under number of week?

aoiu;
DateAdd ("d",-Weekday (fldDATE) +1, fldDATE)
But not always the first day of week - Monday...
Monday becomes the first day of week, as Weekday to specify in the second parameter vbMonday

4

Re: How to calculate date of Monday under number of week?

Akina wrote:

it is passed...
Well year nevertheless is necessary... And with the registration of that in a year of 52 weeks, number 118 looks doubtful...

118 first digit 1 is number of week, and the last two digits 18 is a year.

5

Re: How to calculate date of Monday under number of week?

Amiri wrote:

aoiu;
DateAdd ("d",-Weekday (fldDATE) +1, fldDATE)
But not always the first day of week - Monday...
Monday becomes the first day of week, as Weekday to specify in the second parameter vbMonday

Is only 118 where the first 1 number of week, and last 18 is a year.

6

Re: How to calculate date of Monday under number of week?

aoiu;
=WeekdayName (Weekday (118; 2))
?

7

Re: How to calculate date of Monday under number of week?

y - Number of day in a year (from 1 to 366).
yy - the Last two digits of number of year (from 01 to 99).

8

Re: How to calculate date of Monday under number of week?

Amiri;
dddd - the Full title of day of week (Monday - Sunday).

9

Re: How to calculate date of Monday under number of week?

wrote:

aoiu;
[spoiler]

(DateSerial (2000 + CLng (Right (118, 2)), 1, 1) + ((1 - Weekday (DateSerial (2000 + CLng (Right (118, 2)), 1, 1), 0) + 7) Mod 7)) + ((CLng (Left (CStr (118), Len (CStr (118)) - 2)) - 1) * 7)

[/spoiler]

Thanks, so.

10

Re: How to calculate date of Monday under number of week?