A little help on a logic function

D

Dudley

I have a column, assume column A with a drop-down to leave the cells blank,
select Yes or No. The dropdown was created by validation.
In column B, I want to have todays date plus 7 days inserted if Y is
selected, no date if N is selected. The hang up for me is I dont want the
date to update in the future when the file is opened.
Obviously, =if(a1="Yes",today()+7,"") will update from day to day. I
cant think of a work around for this.

Help
Dudley
 
C

CLR

I think you need another cell with the date the form is filled out typed
in.............then, you could use the formula to +7 that
cell.........."form date" rather than "today"...........

Vaya con Dios,
Chuck, CABGx3
 

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

Help? I need help in making formulas work to accomplish... 0
Conditional Formatting - Cannot get it to work, please help 1
logical functions 6
How do I get a cell to highlight when a deadline date approaching 2
If Function 1
Need a little help with a custom function 1
problem with excel logic, too complicated of a function set??? 3
Automtacally change entry based on value in column. 1

Top