Re find the first Monday in June

[Steved]

Hello from Steved

I've solved first monday in june by using Conditional
Formating using the formula

=DATE(YEAR(L13),6,8)-WEEKDAY(DATE(YEAR(L13),6,6))

It works on no matter what the year is.

Now to get the last Monday in October

Thankyou.

 

[Norman Harker]

Hi Steved!

Again, they'll be more efficient ways but how's this for cheating:

=DATE(YEAR(L13),11,8)-WEEKDAY(DATE(YEAR(L13),11,6))-7

I adapted your preferred formula for the first Monday in June to find
the first Monday in November and then deducted 7. That must be the
last Monday in October.

 

[Steved]

Thankyou Norman

 

[Daniel.M]

=DATE(YEAR(L13),11,8)-WEEKDAY(DATE(YEAR(L13),11,6))-7

or (but substracting 7 to initial date)

=DATE(YEAR(L13),11,1)-WEEKDAY(DATE(YEAR(L13),11,6))

Which is the previous Monday to Nov 1st ;-)

Regards,

Daniel M.

 

[Steved]

Thanks Daniel.

-----Original Message-----


or (but substracting 7 to initial date)

=DATE(YEAR(L13),11,1)-WEEKDAY(DATE(YEAR(L13),11,6))

Which is the previous Monday to Nov 1st ;-)

Regards,

Daniel M.


.