Thread: identifying saturday and sunday in a date

Moved to correct forum!

Try the WORKDAY formula (2007? can't remember if its there for earlier versions). This allows you to point to a start date in a cell, then point to a cell that has number of days it takes to complete the project, and will calculate an 'end date' that is a workday (skips saturday/sunday). The formula also gives you a way to build-in skipping of holidays as well, if you need that.

=WORKDAY(A1,B1,C1:C10))

In this example, A1 is your start date, B1 is the number of days you expect the project to take to complete, and the range C1:C10 is where you can put holidays that you want to 'skip' as well (holidays formatted as 'general', not as 'date'). The formula returns the 'end date', skipping weekends and holidays, that you're looking for, I believe.

Hope that helps!

There's a difference between adding 5 days to a date and then jumping to the next weekday if the result isn't one....and just adding 5 workdays to a date. For example the former gives a Monday end date for a Tuesday start, the latter gives a Tuesday end date.

You describe it as the former which would be

=WORKDAY(A1+4,1)

If it's the latter

=WORKDAY(A1,5)

For versions of Excel before 2007 WORKDAY is an Analysis ToolPak function

...or without Analysis ToolPak function this will do the same as the first formula above

=CHOOSE(WEEKDAY(A1+5),1,0,0,0,0,0,2)+A1+5