Answers for "how to get date and month in excel"

VBA

-1

excel get month from date

# A2 contains '15/09/2021'

# To get month from a date as a STRING
=TEXT(A2, "mm") 			' 9		(string)
=TEXT(A2, "mm") 			' 09	(string)
=TEXT(A2, "mmm") 			' sept
=TEXT(A2, "mmmm") 			' september

# To get month from a date as a NUMBER
=MONTH(DATE(2021,9,15)) 	' 9		(number)
=MONTH(A2) 					' 9		(number)

Posted by: Guest on March-18-2021

Code answers related to "how to get date and month in excel"

Code answers related to "VBA"

Browse Popular Code Answers by Language

Python

Javascript

Whatever

Shell/Bash

CSS

Html

PHP

SQL

Java

C#