Forum Discussion
Solved
Setting Friday as End of Week
Hello, I have a data set that has a list of trip with a Drop Due Date. This drop due date can be any day of the week, but I want to do a count of have the cutoff to be Friday of each week. I am ...
Try:
(Transfers[Drop Due Date] + IF(WEEKDAY(Transfers[Drop Due Date],1) = 7, 6, 6 - WEEKDAY(Transfers[Drop Due Date],1)))
This looks at the day of week and determines, if Saturday then add 6 days otherwise use logic that is already in place.
JayHerrera
Advocate I
Advocate ITry:
(Transfers[Drop Due Date] + IF(WEEKDAY(Transfers[Drop Due Date],1) = 7, 6, 6 - WEEKDAY(Transfers[Drop Due Date],1)))
This looks at the day of week and determines, if Saturday then add 6 days otherwise use logic that is already in place.
Thank you for the quick solution! This worked perfectly!
Jeff
