Forum Discussion

ArchiveUser's avatar
ArchiveUser
Qrew Captain
8 years ago

How to calculate a date for this Friday if date is before Thursday or for the following Friday if date is Thursday or Friday

I want to create a formula date field for client payments when the job completion date is entered. How can I calculate if the [Task Completion Date] is on a Monday, Tuesday, or Wednesday, then the dat...
DanLadner1's avatar
DanLadner1
Qrew Trainee
8 years ago
Try this:
If(  DayOfWeek([Task Completion Date])=1 or  DayOfWeek([Task Completion Date])=2 or  DayOfWeek([Task Completion Date])=3,  FirstDayOfWeek([Task Completion Date])+Days(5),  FirstDayOfWeek([Task Completion Date])+Days(12)  )