Mil05006 ✭✭✭

Overview

Overview

Roles	Member
Badges	7

About Me

About Me

Not much happening here, yet.

Analytics

8

Posts

120

Visits

245

Points

May 3, 2022

Join Date

Nov 13, 2024

Last Active

Reactions

• Awesome 3

  3

• Activity
• Discussions3
• Comments5

• Re: Formula to return Monday from a week a date was on

  Mil05006

  02/22/24
  Thanks! Also, this works as a shortened version- =Date@row - (WEEKDAY(Date@row) - 2)
  1 ·

• Re: Formula to return Monday from a week a date was on

  Mil05006

  02/22/24
  Figured it out- =IF(WEEKDAY(Date@row) > 4, Date@row - (WEEKDAY(Date@row) - 2), Date@row - (WEEKDAY(Date@row) - 2))
  1 ·

• Re: Formula to Count The First Or Second Time Something Has Appeared In A Sheet

  Mil05006

  04/17/23
  Thank you for your response! I used this and kept working on this with a collogue of mine and we came up with this after poking at it for a LONG while and it completely works! =COUNT(COLLECT([Row ID]…
  1 ·