Wednesday, April 14, 2010

Changing Weekend in Excel Workday

If you live somewhere where the weekend is on Friday and Saturday instead of Saturday and Sunday, here is a hack to the Excel Workday function to calculate the correct dates:

WORKDAY(K5+1,5)-1

where K5 holds the date. Just add 1 to the date and subtract 1 from the result.

[source here]

No comments:

Post a Comment