hi
i was trying to enter a date in an excel cell and then write an if statement in another cell to return what month the date was for. i tried the following statement.
=IF(A1="MM/DD/YYYY","DD","") the formula returned false.
i enter the following date in cell A1 6/13/2008
if the cell doesnt contain a date it should remain blank. if it does return the month it is.
is it possible to have the result show as the spelling of the month instead of the number
i.e if its the 6th month in the date the formula would return June.