activate formula when adjacent cell populated

S

Simon

Dear All,
I have copied a simple formula (A1+1095) down the length of column B
(working with excel 2003). A1 contains a date, the formular in column B
produces a date 3 years later, with conditional formatting added to indicate
how close the future date is getting. The problem I have is that where there
is no date yet entered into a cell in column A, the remainder of column B
automatically displays 30/12/1902 and formats the cells red (for the rest of
the entire column). Is there a way to direct the formula in column B to only
become active once a date has been entered into the adjacent cell in column
A? - I was thinking along the lines of an IF statement or similar as I am
prohibitted from using a macro.
Advice gratefully recieved.
Simon.
 
A

Arvi Laanemets

Hi

=IF(A1="","",A1+1095)

Or
=IF(A1="","",DATEDIFF(YEAR(A1)+3,MONTH(A1),DAY(A1))


Arvi Laanemets
 
P

Pete_UK

Try this:

=IF(A1="","",A1+1095)

You may need to adjust your CF formula to avoid zero values.

Hope this helps.

Pete
 

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

Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Date diffrence in days, weeks and months. 1
Cumulative formula for word table 0
Copy addition formula of non-consecutive horizontal cells 2
Copy corresponding cell in Column B if cell in A contains certain text? 1
Getting a formula to reflect added columns 10
Autonumber field in Excel that behaves the same as Access 0

Top