Excel Add 60 days to column 1 or column 2 based on whether column 2 has data

B

bellestella

Joined
Feb 22, 2018
Messages
1
Reaction score
0
Hi,

How can I add 60 days to column 1 or column 2 based on whether column 2 has data? I1 is A1 plus 60 if A2 if blank and I1 is A2 plus 60 if it is not blank.

Thanks,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2 into 1 6
Excel Concatenate cell data from column based on criteria in adjacent column 2
Excel Concatenate addresses in Excel but avoiding blanks, and line breaks 6
Access Counting records based on multiple age bracket and output to tabulated report 0
Excel VBA 1
Excel Excel: How do I put a formula in a drop down list 11
Excel Worksheet_change with 2 functions to insert date and hyperlink window 0
Excel Reference to text returning "0" value on second column 0

Top