Last Friday of the Current Month
I am needing help in finding a formula for a Formula-Date field to show the last Friday of the Current Month by default when adding a record. I appreciate any help with this! ---------------------...
Forum Discussion
This worked perfectly! Thank you very much!
------------------------------
Tanya Hammil
------------------------------
------------------------------
Tanya Hammil
------------------------------
I ran across this while looking for something else. Here's an alternative:
If(DayOfWeek(LastDayOfMonth([Today()])) = 5, LastDayOfMonth([Today()]), PrevDayOfWeek(LastDayOfMonth([Today()]), 5))
------------------------------
Paul Peterson
------------------------------
If(DayOfWeek(LastDayOfMonth([Today()])) = 5, LastDayOfMonth([Today()]), PrevDayOfWeek(LastDayOfMonth([Today()]), 5))
------------------------------
Paul Peterson
------------------------------