Forum Discussion

AlanJNankervis's avatar
AlanJNankervis
Copper Contributor
May 07, 2020

Round up to the nearest Tuesday or Thursday

I have a formula that can calculate the days required to produce a product. But we only want to send the product out on a Tuesday or Thursday.   I need a formula that will round my projected date u...
Formulas and Functions
amit_bhola's avatar
amit_bhola
Iron Contributor
May 07, 2020

AlanJNankervis Hi,

WEEKDAY function returns which day of the week it is for a given date. Using WEEKDAY and IF , a long looking but easy to understand and maintain formula is below :-

 

=IF(OR(WEEKDAY(V4)=3,WEEKDAY(V4)=5),V4,IF(OR(WEEKDAY(V4)=2,WEEKDAY(V4)=4),V4+1,IF(WEEKDAY(V4)=1,V4+2,IF(WEEKDAY(V4)=7,V4+3,IF(WEEKDAY(V4)=6,V4+4)))))

 

a sample file is also attached.

Resources