Home

Excel Formula

%3CLINGO-SUB%20id%3D%22lingo-sub-776593%22%20slang%3D%22en-US%22%3EExcel%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-776593%22%20slang%3D%22en-US%22%3E%3CP%3EI%20want%20a%20formula%20that%20lets%20me%20add%2010%20(days)%20to%20a%20date%20only%20IF%20a%20date%20is%20entered%20into%20a%20particular%20column.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-776593%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-776644%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-776644%22%20slang%3D%22en-US%22%3EIf%20the%20Column%20on%20which%20you%20want%20to%20determine%20the%20presence%20of%20a%20date%20is%20Column%20A%2C%20the%20date%20to%20which%20you%20may%20add%2010%20days%20is%20in%20B1%2C%20and%20the%20formula%20cell%20is%20C1%2C%20enter%20this%3A%3CBR%20%2F%3E%3D(SUMPRODUCT(%E2%80%94ISNUMBER(A%3AA))%26gt%3B0)*%3CBR%20%2F%3E10%2BB1%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-776646%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-776646%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F383385%22%20target%3D%22_blank%22%3E%40lritterskamp%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20assumes%20that%20the%20date%20you%20are%20working%20with%20is%20a%20proper%20date-value%20and%20not%20a%20text%20string.%3C%2FP%3E%3CP%3E%3CFONT%3EThe%20formula%20%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%3CSTRONG%3E%3CFONT%3E%3D%20IF(%20date%2C%20date%2B10%2C%20%22%22%20)%3C%2FFONT%3E%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%3CFONT%3Emoves%20forward%20by%2010%20days%20whereas%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%3CSTRONG%3E%3CFONT%3E%3D%20IF(%20date%2C%20WORKDAY(date%2C10)%2C%20%22%22%20)%3C%2FFONT%3E%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%3CFONT%3Eignores%20weekends.%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
lritterskamp
Occasional Visitor

I want a formula that lets me add 10 (days) to a date only IF a date is entered into a particular column.  

2 Replies
Highlighted
If the Column on which you want to determine the presence of a date is Column A, the date to which you may add 10 days is in B1, and the formula cell is C1, enter this:
=(SUMPRODUCT(—ISNUMBER(A:A))>0)*
10+B1

@lritterskamp 

This assumes that the date you are working with is a proper date-value and not a text string.

The formula

= IF( date, date+10, "" )

moves forward by 10 days whereas

= IF( date, WORKDAY(date,10), "" )

ignores weekends.

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies