Timestamp / Date Formulas

[moni_tm]

Good Afternoon,

Please can you help.

I need some help with the following formula.

=IF(R387="Yes",NOW(),0)

when true, i want the date to be displayed to be the current date, however, when I open the spreadsheet in future, i do not want the date to update.
Any ideas?

Tom

[Fotis1991]

Hi

You need TIMESTAMP. See the link for how to do this.

http://www.mcgimpsey.com/excel/timestamp.html

[moni_tm]

Sorry I cant quite get that to work.

[Fotis1991]

Upload a small sample workbook.

As i have to leave the office now, if anyone else will not help you, i'll show to you tomorrow morning how to do this.

[moni_tm]

Formula problem.png

Does this help?

I would like the timestamp to appear in column V if column R has a Yes Value.

Thank you.

Tom

[sourabhg98]

Or maybe like this

[moni_tm]

Thanks for trying Sourabhg98 but that does not help me.

[moni_tm]

Would this formula work,

=IF(R560="Yes",NOW(),"")

Or will it update the date the following day?

Appreciate the help and guidance.

Tom

[sourabhg98]

In which column do you need the date?
H or I??

[moni_tm]

I need the timestamp to appear in column V if "Yes" appears in Column R.

[FDibbins]

=IF(R560="Yes",NOW(),"")

This will update with ANY workbook change

Also, Please upload a sample of your workbook, not a picture of your data. Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you
Also, not all members can upload picture files (Company firewalls and stuff)

Your workbook should show a small desensitized example of the data you are working with and a manual mockup of the expected results.

[sourabhg98]

Try it now

[moni_tm]

This is a basic example of what i need, does this help?

[printing]

Hello I was wondering if you can help me or point me in the right direction with this thank you in advance for your assistance.

Please help I need to extract from one cell to individual cell for each piece of info.

format eg: date store name name1, state price
00/00/00 shoprite springfield S1, NJ 67.64

I would need a cell for each one like date, store name, & price. PLEASE HELP i havebeen stuck on this for over a week. thank you inadvance for any assistance.

[FDibbins]

printing, welcome to the forum

for the 2nd time...
Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.

[Fotis1991]

OK. Here you are.

Please Login or Register  to view this content.

IMPORTANT!!
Using circular references and worksheet functions

You can use a circular reference to enter the time when a change is made in another cell, then maintain that time. Choose*Tools/Options/Calculation(Preferences/Calculation*for Macs) and check the*Iteration*checkbox.

[moni_tm]

Many Thanks Fotis1991

Tom