Skip to main content
Question

Formula date field third Wednesday

  • March 18, 2020
  • 0 replies
  • 39 views
  • Del
  • Quickbase Alumni
Looking for a formula date field calculating the third Wednesday after a date field "Assignment Date" for example;

If the "Assignment Date" is today (18th of March) then this "Date field (Lets call it "End Date"" should show 8th of April.

------------------------------
Ermias Bean
------------------------------
This topic has been closed for replies.

  • BrandonDrake
  • Quickbase Alumni
  • March 18, 2020
Hello Ermias, 

I think the best way to achieve this would be to use the NextDayofWeek([Assignment Date], 3) to find the next Wednesday and then add 21 days.  I think this may work.

if(DayofWeek([Assignment Date] !=3,
NextDayofWeek([Assignment Date], 3) + Days(21),
[Assignment Date] + Days(21))

The only caveat is you did not really explain what happens if the assignment date is a Thursday.  Is it then the third Wednesday after the next Wednesday, or is that next Wednesday part of it, then that would make the formula more complicated, but still doable.

------------------------------
Brandon Drake
JHI Group
Monroeville OH
------------------------------
Terms & ConditionsAccessibility statement