i have one cell one date 12/05/2017 in another cell it need to come 12/05/2017 + 30 days = 12/06/2017 how to bring that ?
i have one cell one date 12/05/2017 in another cell it need to come 12/05/2017 + 30 days = 12/06/2017 how to bring that ?
if you have your date in A1 Then try below formula
=A1+30
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
its not working
It is working in my PC, I think date format you entered is not your system date format, please change the date format
If your date in "A2" enter formula in "B2"
Formula:Please Login or Register to view this content.
Both format as "dd-mmm-yyyy"
atul
If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.
Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".
awesome thanks alot
this one is worked fine =INT(A2+30).. hatts off all
If you are dealing with dates, and just adding days to them, not sure why you would need to use INT()?
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
Agree with Mr. Ford statement, as dates are store in excel as numbers and if we add any number into the date in excel it should work and make changes in dates.. May be as Post #5, Mr. Siva suggest your system date format is not matching with your entered date in excel cell.
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
yes my system date format is mm/dd/yyyy. I need to work with it only. see this attachment. It was not working =+cell no + 30 days its not working.
This seems to be the same now as your other thread here?
https://www.excelforum.com/excel-new...m-dd-yyyy.html
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks