Calendar help

[Ray_Torres]

With the A1 cell name equalling the name of a month how can I get the A2 cell to give me the first day of that month? or if easier I just need a calendar that will allow me to change the cell dates by changing the month in A1.

 

[Dave Patton]

What have you tried?

What are the Regional date settings for your system?

Try

T202206a.xlsm
	A	B	C
1
2	June	1-Jun-22	Systems set to International Date format
3	June	1-Jun-01	May give correct date with USA based systems
4	June	1-Jun-22
5
1b

Cell Formulas
Range	Formula
B2	B2	=--(1&A2)
B3	B3	=--(A3&1)
B4	B4	=DATE(2022,MONTH(A4&1),1)

 

[Ray_Torres]

Thank you for the help, I ended up going with, =DATEVALUE("1-"&D1&"-"&F1). Using month in D1 and year in F1.