Hi, Need some help and have no idea!
I have a column of dates (uk format) i.e 01/12/2010 02/05/2011 24/11/2001 . I need another column with Quarterly dates associated to those dates. Therefore 01/12/10 in column A, Q4 2010 in column B........ etc.
Sorry if i am coming across patronising, ot intended, just trying to be clear as i am pulling my hair out in attempting this. Sure its simple to some.....
Using an old 2003 excel at work.....
Any help much appreciated. Thanks.
="Q"&Int((Month(A1)-1)/3)+1&" "&Year(A1)
Life is about perseverance. Remember: today's mighty oak tree is just yesterday's nut that held its ground.
If you like a post, please rate it with the scales icon (top right).
If you feel really indebted, please consider a donation to charity, such as Feed the Children or Habitat for Humanity.
Works a treat, thanks very much.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks