On 2002-04-09 18:32, seeya wrote:
I want to enter a due date in a spreadsheet and setup another cell to calculate the start date. The start would be x weeks prior to the due date . And I want to calculate this based on a 5 day work week. Any suggestions?
=WORKDAY(start_date,-x)
-x equals total number of workdays prior to start_date. make sure result cell has date format.