I work for a planning company where we submit lots of applications to do with housing. Different application types have different lengths until decision and completion so I want something like the following for each row:
If submission date=mmddyy and cell=application type 1 then decision date = 21 days later and completion date = 30 days later.
Assume I need an IF statement and a VLOOKUP but not really sure. Any help would be awesome!