Thread: Date Question
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gina[_2_] Gina[_2_] is offline
external usenet poster
 
Posts: 49
Default Date Question

This is probably very simple, but no amount of caffeine is helping me think
this morning- so I'm hoping I can get help.

Cell A2: =YEAR(C2)
Cell B2: =INT((MONTH(C2)-1)/3)+1


These two cells return the value of Year and Quarter for a date that is
posted in Cell C2. What I'd like is to be able to have NO value returned if
there is a date in this cell. Currently if the cell is empty, Cell A2
defaults to year 1900, and Cell A3 returns 1 for 1st Quarter.