Let's say you have a date formatted as 31/Dec/16 but wanted to calculate two cells over to show 201612. How would I put in this formula because excel and sharepoint do not have it already formatted in the system?



You can try below formula

=YEAR([DateField]) + MONTH([DateField])


=TEXT([DateField], "YYYYMM")
  • I'll see what it comes up with. – J. McCormick Jul 14 '16 at 17:26
  • Used the formula above for the date 29-Jul-16 and it comes out to be 2023? – J. McCormick Jul 14 '16 at 17:45
  • 2
    Check my updated answer – Amal Hashim Jul 14 '16 at 17:49
  • Amal Hashim - WORKED – J. McCormick Jul 14 '16 at 17:59
  • Now the formula won't stay when I hit refresh from an external data connection? – J. McCormick Jul 14 '16 at 19:18

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.