Forum Discussion

amorrissen's avatar
amorrissen
Copper Contributor
Mar 19, 2021

Extract Number from Date that has Format Applied

I have a date in cell A1 as follows: 4/1/2021 A1 has date formatting applied so the cell displays: April 2021   I want to extract just the numerical month value from A1.   I tried =LEFT(A1,1) bu...

Resources