Round Date to Nearest Workday

[nationwide]

Good day! I'm attempting to write a formula that rounds a given date it to the nearest workday. For example, If I have the dates January 23, 2010 (which is a Saturday) and January 24 ,2010 (which is a Sunday) I want the formula to return January 25, 2010 (Monday). However, if the date is January 22, 2010 (a Friday), I want the forumula to return that date since it's a workday.

Any help would be much appreciated!

 

[Wannabepro]

=if(weekday(a2)=1,a2+1,if(weekday(a2)=7,a2+2,if(weekday(a2)=6,a2-1,a2)))

 

[Wannabepro]

=if(weekday(a2)=1,a2+1,if(weekday(a2)=7,a2+2,if(weekday(a2)=6,a2-1,a2)))

is there a way to round every friday to thursday on top of rounding every sat & sun to monday?

 

[Ashik]

Good day! I'm attempting to write a formula that rounds a given date it to the nearest workday. For example, If I have the dates January 23, 2010 (which is a Saturday) and January 24 ,2010 (which is a Sunday) I want the formula to return January 25, 2010 (Monday). However, if the date is January 22, 2010 (a Friday), I want the forumula to return that date since it's a workday.

Any help would be much appreciated!

Hi
If i want to take the weekend to be friday & saturday how can i amend this formula to find the same