Elsie M said:
How can we format cells to convert to 1st qtr, 2nd qtr, 3rd qtr or 4th qtr
when a date is input such as 3/30/03 which would convert to 1st qtr.
=roundup(month(source data)/4,0)
Not sure exactly what that month function is called, it shoud get the
month as a number from 1-12. If you want it as text, you could enter teh
season names somewhere and use a vlookup on that table with the above
number.
--
--
Fabian
Humans have to stop treating each other like they treat us ants. Think
about it. If we build, say, a pair of very tall structures, like two
anthills side-by-side, some stupid human swoops in out of nowhere and
knocks them down. Or humans will drop food on the ground near us. we
think it's for us, but those same humans will also try to kill us! I
have no sense of irony, I'm just an ant. But if I did, I'm sure I'd
notice that.
