How to change the dates in series of columns just by changing the date in a single column
Hi experts,
Please look in to the attached data sheet. Here I have dates in row no 2 starting from column M. What I need is to have a formula that changes the dates forward automatically when only the date in M2 changes to the current date.
Currently, I do this by changing the date in M2 and drag it all the way forward by holding the left mouse button.
Thanks in advance
try this, copied across...
=M2+1
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Just tried, It just changes to "0 -Jan", but how to get back to current date?? An, when I type the current date, it will also delete the formula, won't it?
I used that in your file and it worked just fine...
N2=M2+1 copied across
Test for posting as User Saarang84, complained that can not post in this particular thread.
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.
This is a test post
If my assistance has helped, there is a reputation icon * on the left hand corner below the post - you can show your appreciation to the user who has helped in resolving your requirement.
If your requirement has been solved please mark your thread as Solved.
In the menu bar above the very first post, select Thread Tools, then select "Mark this thread as Solved".
Kindly use [FORMULA] or [CODE] tags when posting your code.
Regards,
Sarang
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks