Can anyone help me with a formula that would allow me to program cells with dates in which I add a certain number of days to the next cell for something to be worked on but don't want to include weekends, or be able to automatically add 2 to account for weekend days? I am doing this on an extended time line and don't want to have to manually account for the weekend days each time.
ex. =A1+ 6 (where A1 is a date and the 6 goes over a weekend).
thanks!!
Bookmarks