month text to number formula

[biglb79]

I'm rolling forward financials and have a budget number for the month on worksheet 3 in cell M1, so right now it's 7 for July. Is there a way I can have it change to 8 when I roll forward the financials? I would have the month name August on worksheet 1 cell D5.

 

[CodeNinja]

Biglb79,
If Sheet1!D5 will always have the month you want to reference, you could use the following formula:
=MONTH(DATEVALUE(Sheet1!D5&" 1, 2017"))

Good luck,
CN.

 

[biglb79]

perfect, thanks!