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.
|