Fixed date with IF-function (or any other ideas?)

P

p11p00

Is it possible to add a fixed date automatically with if-function.

I want to add a date to a neighboring cell when it is not empty – meaning
date is added automatically to A1, when someone is writing to neighboring
cell A2. With “ IF(D3="";"";(TODAY()))†-function returns always the current
date, not the date of writing.
 

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

Newbie Help - IF Yes No Function 0
Use TODAY() function as the criteria in a SUMIF formula 1
=IF function with current date 3
I have lost 6 months work, how can i get my file back 1
Regarding NESTED IF formula 4
Template with fields and premade texts.. 0
Problem with SET & REF function 0
"If" function and Upcoming Dates 1

Top