Hello there,
I want to to create such a formula when I enter data in column B then it should be display date of today in column C. I want to make the next day will be keep another day as a previous date. How will it be possible? Please help. Your suggestion will be highly appreciated. Thank you.
Indra Rai
Last edited by Indra Rai; 02-06-2012 at 03:52 AM.
Hi
You van use today() if you want always today date that will updated automatically
Or
Based on the difference between two systems Try thisot
RegardsH7: =IF(E7="","",E7-20711)+H7
Mahju
Mark the thread as solved if you are satisfied with the answer
Rule 9
Acknowledge the responses you receive, good or bad. If your problem is solved, please say so clearly, and mark your thread as Solved: Click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Edit button will not appear -- ask a moderator to mark it.
Hello Mahju,
Thanks for your prompt reply. I put your code but no response to me. I don't want to keep =today() formula because I want to keep record of date.
Hi
Take a look to this.
http://www.exceltip.com/st/Creating_...Stamp/955.html
Hope to helps you.
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/
Hi
Sorry
Please see the attached
Regards
Mahju
Mark the thread as solved if you are satisfied with the answer
Rule 9
Acknowledge the responses you receive, good or bad. If your problem is solved, please say so clearly, and mark your thread as Solved: Click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Edit button will not appear -- ask a moderator to mark it.
Hello mahju,
I tried with your code... but slightly my requirement is different. I want to display date of today on the basis of name only. Please see attachment. Thank you.
Indra
I insist on what ι suggest!!!...
http://www.exceltip.com/st/Creating_...Stamp/955.html
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/
Hello fotis1991,
I also tried according to your link. Could you make sample for me please. Thank you.
Indra
Hi
Yes i can do it!!
But after my lunch...!!
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/
Hi
In D25, of your example, put this.
=IF(B25="";"";IF(D25="";NOW();D25))
. Go to Tools Options Calculation Tab Check the Iteration checkbox, to be 1. Not 100!!
Hope to helps you.
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/
Hi
Another solution
simpler but somewhat semi-automatic
Tye the start date and write "N" in the new day column at the start of day. Your dates will be increased by 1
see attached also
hope it help
Regards
Mahju
Mark the thread as solved if you are satisfied with the answer
Rule 9
Acknowledge the responses you receive, good or bad. If your problem is solved, please say so clearly, and mark your thread as Solved: Click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Edit button will not appear -- ask a moderator to mark it.
Hello fotis1991,
Thank you so much for your kind cooperation. That's it what I want. Now, on the basis of the formula I want to create another formula which translate to Bikram sambat. Thanks once again.
And I would also like to thank you mahju for you kind cooperation.
Indra
Last edited by Indra Rai; 02-05-2012 at 12:17 AM.
You are welcome
Pls mark your thread, as SOLVED.
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/
hi
there is a thread about convertion at
http://www.excelforum.com/excel-gene...l-formula.html
Regards
Mahju
Mark the thread as solved if you are satisfied with the answer
Rule 9
Acknowledge the responses you receive, good or bad. If your problem is solved, please say so clearly, and mark your thread as Solved: Click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Edit button will not appear -- ask a moderator to mark it.
I forgot how to mark "Solve". Please suggest..
Thank you.
Indra
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks