Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 318
  • Last Modified:

Excel date formula

hi there;

i'm in need of a formula or maybe a macro;

the thing is that I have a column including dates like;

13.Sept
15.Sept
13.Sept
22.Sept
01.Sept
24.Sept
25.Sept
19.Sept
26.Sept

what I need it;

I want excel to revise these dates to;

"date specified in the cell + 2  - Sept"

i.e

13.Sept - should be read as 13/15 Sept
15.Sept - 15/17 Sept
13.Sept - 13/15 Sept

Any so on

Would that be possible please?

appreciate to hearing from your side


0
Sirjasonn
Asked:
Sirjasonn
3 Solutions
 
Shanmuga SundaramDirector of Software EngineeringCommented:
Please see that attached and let me know is this what you need?
res.xls
0
 
nike_golfCommented:
Try this assuming G1 is the starting cell:

=LEFT(G1,2) &"/"& LEFT(G1,2)+2 & " " &MID(G1,4,LEN(G1))

0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Hello,

if the cell contains a real date, then you can use

=DAY(A1)&"/"&TEXT(A1+2,"dd mmm")

cheers, teylyn
0
 
SirjasonnAuthor Commented:
Thanks very much for all yours kind assitance.

All were helping me a lot to conclude this
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now