ContributionsMost RecentMost LikesSolutionsRe: Date Add Formula That was almost it, it was just expecting another parenthesis on the end but thank you for helping I see what I did wrong! ------------------------------ Justin Olsen ------------------------------ Date Add Formula Our fields have various stages for the status (0%, 30%,... 100%). We also have fields for arrival date and quoted lead times that get added together to populate a promise date. What I want to do is when the order is set to 100% Closed Won (from the drop down option on the form) AND and arrival date is populated the quoted lead time is then added to the arrival date to generate a promise date. I feel like I'm close with the following. IF([Status]="100% Closed Won") WeekdayAdd([Arrival Date], [Quoted Lead Time]) ------------------------------ Justin Olsen ------------------------------