Need to add Date difference of 15 days
Could any one please suggest me with formula or macro to add up a dates of 15 days difference as mentioned below:
01-01-2014 Jan-01
15-01-2014 Jan-15
01-02-2014 Feb-01
15-02-2014 Feb-15
01-03-2014 Mar-01
Need to add Date difference of 15 days
Could any one please suggest me with formula or macro to add up a dates of 15 days difference as mentioned below:
01-01-2014 Jan-01
15-01-2014 Jan-15
01-02-2014 Feb-01
15-02-2014 Feb-15
01-03-2014 Mar-01
I suggest you use a proper date format first
If you have a real date and want to increase that by 15 (or 1/2 a month) try using the EDATE() function...
=EDATE(A1,0.5)
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks