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 04: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
Regards
Please Login or Register to view this content.
Mark the thread as solved if you are satisfied with the answer.
In your first post under the thread tools.
Mahju
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.
-This is my Greek whisper to Europe.
--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.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Hi
Sorry
Please see the attached
Regards
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
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...!!
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.
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
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 01:17 AM.
You are welcome
Pls mark your thread, as SOLVED.
hi
there is a thread about convertion at
http://www.excelforum.com/excel-gene...l-formula.html
Regards
I forgot how to mark "Solve". Please suggest..
Thank you.
Indra
Click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks