Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Date Question | Excel Discussion (Misc queries) | |||
DATE Question | Excel Discussion (Misc queries) | |||
Date Question | Excel Discussion (Misc queries) | |||
Date Question | Excel Discussion (Misc queries) | |||
Date Question | Excel Discussion (Misc queries) |