Excel functions

%3CLINGO-SUB%20id%3D%22lingo-sub-1845063%22%20slang%3D%22en-US%22%3EExcel%20functions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1845063%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20set%20an%20excel%20document%20function.%20In%20%22C%22%20the%20person%20date%20of%20hire%20is%20listed.%20Is%20there%20a%20function%20that%20will%20automatically%20assign%20the%2090%20day%20eval%20date%20in%20the%20next%20(%22D%22)%20section%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1845063%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EHow-to%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1850726%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20functions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1850726%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F854697%22%20target%3D%22_blank%22%3E%40smckenzie09%3C%2FA%3E%26nbsp%3BAssuming%20the%20date%20of%20hire%20is%20in%20C2%2C%20the%20formula%20in%20D2%20could%20be%20%3DC2%2B90%20to%20give%20you%20the%20evaluation%20date.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I am trying to set an excel document function. In "C" the person date of hire is listed. Is there a function that will automatically assign the 90 day eval date in the next ("D") section?

1 Reply

@smckenzie09 Assuming the date of hire is in C2, the formula in D2 could be =C2+90 to give you the evaluation date.