Display First day of Any Given Month based on the month selected in another cell.

English
#1

In, A1, I have drop down list of months from Jan. - Dec. , For Example April is selected from that list, in cell B1 it should display sth like
04-01-17 - (MM-DD-YY) First day of the month.

#2

Hello @inflictedd,

in cell B1 you could write a Formula such as:

=DATEVALUE("1 " & A1 & " " & YEAR(TODAY()))

( make sure that the cell Format for cell B1 is set to Date Format: - “MM-DD-YY” )

#3

it doesn’t seems to work

#4

i think that the items in the dropdown list must be full month names, e.g. “January” “December” etc

#5

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.