Number Format #2

  • Thread starter Thread starter mars
  • Start date Start date
M

mars

Hello
Can't get this formula to work with 1999/00 - should read 01/07/2000
instead shows 01/07/1900


="31"&"/"&"1"&"/"&LEFT(B3,2)&RIGHT(B3,2)

Much obliged if you can help....


Mars
 
Hello
Can't get this formula to work with 1999/00 - should read 01/07/2000
instead shows 01/07/1900

="31"&"/"&"1"&"/"&LEFT(B3,2)&RIGHT(B3,2)

Much obliged if you can help....

Mars
Click to expand...

On my machine, it shows:

31/1/1900
 
Try
="01"&"/"&"07"&"/"&Left(B3,4)+1 - or "01/07/"&Left(B3,4)+1
or for end of year?
="30"&"/"&"06"&"/"&Left(B3,4)+1 - or "30/06/"&Left(B3,4)+1
Junge
 
All
Many thanks for your replies and apologies for the error in my
message.

Junge, your offer worked!


Mars
 
Back
Top