Monday

1

Solutions

15

Contributors

We're obsessed with building an excellent product, and our goal is to create a tool that people will love to use—one that’s fast, beautiful, responsive, and makes your life easier. The only thing we love more than our product is our customers. The incredible teams that use our product are the most important thing to us, and we're here to provide support to them 24/7.

Share tech news, updates, or what's on your mind.

Sign up to Post

I want to add a conditional formatting to the cells in column G ( 7 - 22) . I want the cells to highlight a certain color blue (RGB 183, 222, 232) if the ship date in column H is delinquent based on today's date OR if the ship date carries through to Sunday of that week. For example today is Monday, Sept 10th. The cells in column G should highlight if the ship date is through Sunday, Sept 16th.

Second, is it possible to also to write a formula in cell H31 to automatically sum up all cells that are highlighted in the blue in column G so that I don't have to manually do the sum each time I move lines around?

Third, is it possible to also to write a formula in cell H32 to automatically sum up all cells that are highlighted in the purple (RGB 204, 192, 218) in column K so that I don't have to manually do the sum each time I move lines around?

Fourth, is it possible to write a formula in cell G32 to automatically sum up all cells that are highlighted in the green (RGB 0, 255, 0) in column K so that I don't have to manually do the sum each time I move lines around?
FCS-TRAINING.xlsx
0
Hi Experts,
I had asked a question about First Monday & Third Monday of the week couple week ago and Expert Gustav Brock gave me the Public Function which works but when I tried to place to another form, it does not work as it suppose.  I know I did something wrong, but did not what I miss.  below is my code on a datefield:
Private Sub PDFIRSTCRTDATE_Exit(Cancel As Integer)
Dim DateInMonth As Date
DateInMonth = Date

    If Me.HoldCalA = "Cal 24" Or Me.HoldCalA = "Cal 42" Or Me.HoldCalA = "Cal 54" Then
       If Me.PDFIRSTCRTDATE = DateWeekdayInMonth(DateInMonth, 1, vbMonday) Or Me.PDFIRSTCRTDATE = DateWeekdayInMonth(DateInMonth, 3, vbMonday) Then
       Else
          MsgBox "You have schedule on the wrong Monday for the " & Me.HoldCalA & "."
       End If
    End If
  End Sub



Here is the Public Function from Gustav Brock:
' Calculates the date of the occurrence of Weekday in the month of DateInMonth.
'
' If Occurrence is 0 or negative, the first occurrence of Weekday in the month is assumed.
' If Occurrence is 5 or larger, the last occurrence of Weekday in the month is assumed.
'
' If Weekday is invalid or not specified, the weekday of DateInMonth is used.
'
' 2016-06-09. Gustav Brock, Cactus Data ApS, CPH.
'
Public Function DateWeekdayInMonth( _
    ByVal DateInMonth As Date, _
    Optional ByVal Occurrence As Integer, _
    Optional ByVal Weekday As VbDayOfWeek = -1) _
    As Date
   
    Const DaysInWeek    As Integer = 7
   
    …
0
I had this question after viewing SharePoint Calculated Field - Always Monday of Week Created.

I have a similar requirement but in my scenario, week should start from Thursday.

If any one is creating new item between 24/08/2018 - 30/08/2018, it should show the week start/created  23/08.
0
We currently use Visual Studio 2008 v9.0.  When one user opens a proc on Monday (but does not check it out as they have no intention at that time to make changes) if another user checks out the proc on Tuesday , makes changes and checks it in.  There is nothing to stop the first user from making changes to the proc as he/she  has it in front of him (fro  Monday) and overwrite the changes that user 2 made on Tues.
Is there a way to prevent this - e.g. automatically refresh, or not allow changes checked in if not using the latest file or the problem seems to be that if you have a proc open, you can directly make changes and it will then get flagged as checked out, perhaps if this could be disabled so that the only way to check out a proc would be to reopen from scratch
0

Monday

1

Solutions

15

Contributors

We're obsessed with building an excellent product, and our goal is to create a tool that people will love to use—one that’s fast, beautiful, responsive, and makes your life easier. The only thing we love more than our product is our customers. The incredible teams that use our product are the most important thing to us, and we're here to provide support to them 24/7.

Top Experts In
Monday
<
Overall
>