View Single Post
  #1   Report Post  
LyndieBee
 
Posts: n/a
Default Date in an IF statement

I'd like to be able to evaluate the current date and have the name of the
previous month display in a cell. For example if I'm in cell A1 I want the
statement to check today's date (March 8, 2005) and return last month's month
"April". Can I accomplish this with an IF statement? Any other function?
Many thanks, Lyndie