DashboardNovice
Member
Hi,
I have the following formula:
=IF(DATE(YEAR($C$7),MONTH($C$8),ROWS($A$12:A12))>$C$8,"",DATE(YEAR($C$7),MONTH($C$8),ROWS($A$12:A12)))
The value in cell C8 is 'March.' This formula is not working because March is a text value. I am trying to find a function that can take a month name and convert it is a number 1 through 12, so that the DATE ( ) will work.
I have the following formula:
=IF(DATE(YEAR($C$7),MONTH($C$8),ROWS($A$12:A12))>$C$8,"",DATE(YEAR($C$7),MONTH($C$8),ROWS($A$12:A12)))
The value in cell C8 is 'March.' This formula is not working because March is a text value. I am trying to find a function that can take a month name and convert it is a number 1 through 12, so that the DATE ( ) will work.