Thread: using =month(c2) if c2 is blank returns a 1, which messes up data
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Roger Govier[_10_] Roger Govier[_10_] is offline
external usenet poster
  
Posts: 15
Default using =month(c2) if c2 is blank returns a 1, which messes updata
Hi

A blank cell will be treated as 01/01/1900 if blank and trying to do date
calculations, hence it returns month 1.

You will need to do a check If Isnumber() before carrying out the Month()
function.

Regards

Roger Govier


MHY wrote:
Reply With QuoteReply With Quote