I need to print the date when in the other cell appears ok (eg when I write in "a1" cell "ok" i want to function that will print current date in b1 and that date to stay tomorrow and evry other day, i have tried with DATE() but on date change it change all cells date too
Without vb script because I am using the Excel 2008 for Mac that lacks support for VB.
Thanks in advance
in my opinion without Vba it is impossible
Regards
tom1977
If You are satisfied with my solution click the small star icon on the left to say thanks.
You have posted in an Outlook forum. Is that your intention?
Quoting entire posts clutters the forum and makes threads hard to read !
If you are pleased with a member's answer then use the Star icon to rate it
Click here to see forum rules
sorry I accidentally chose the wrong forum, can any moderator move it to Excel?Originally Posted by arthurbr
Thanks
Hi
In B1, put the formula:
=IF(A1="";"";IF(A1="OK";NOW();B1))
In A1, type OK.
Look the resunt. It will not chance tomorrow.
Hope to help ypu.
Last edited by Fotis1991; 11-25-2011 at 04:58 AM.
Regards
Fotis.
I am proud that i am Greek.
Just to know every one.We Greeks, we are nοt proud of our politicians. Υou?
Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Please,mark your thread [SOLVED] if you received your answer.
My Avadar picture, is from Athens Acropolis.
http://www.theacropolismuseum.gr
http://www.visitgreece.gr/
Thread moved .
Please do not quote entire posts unnecessarily
Quoting entire posts clutters the forum and makes threads hard to read !
If you are pleased with a member's answer then use the Star icon to rate it
Click here to see forum rules
Fotis
NOW() changes when any calculation is performed ( volatile function). Definitely not the way to go
Quoting entire posts clutters the forum and makes threads hard to read !
If you are pleased with a member's answer then use the Star icon to rate it
Click here to see forum rules
[Qdelete the post sorry not seen the moderators sigh..
Regards
Fotis.
I am proud that i am Greek.
Just to know every one.We Greeks, we are nοt proud of our politicians. Υou?
Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Please,mark your thread [SOLVED] if you received your answer.
My Avadar picture, is from Athens Acropolis.
http://www.theacropolismuseum.gr
http://www.visitgreece.gr/
arthurbr
Sorry for the post.
I had not seen your message.
I tried to delete my message but could not.
Please, can you tell me how can I do this??
Regards
Fotis.
I am proud that i am Greek.
Just to know every one.We Greeks, we are nοt proud of our politicians. Υou?
Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Please,mark your thread [SOLVED] if you received your answer.
My Avadar picture, is from Athens Acropolis.
http://www.theacropolismuseum.gr
http://www.visitgreece.gr/
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks