LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
KC KC is offline
external usenet poster
 
Posts: 107
Default Formula for Dates

Cell L4 has a date in it, I'd like a formula that can look at the date and
return the quarter & year. For instance 10/15/2009 would be 3Q2009,
03/12/2010 would be 1Q2010. Thanks very much!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Dates formula orquidea Excel Worksheet Functions 5 October 25th 07 02:09 AM
formula for dates ghynes Excel Worksheet Functions 1 March 27th 07 07:53 PM
Need a Formula for DATES Debbie Excel Worksheet Functions 2 November 8th 05 02:46 PM
how do I use if formula using dates? Simone Excel Worksheet Functions 4 November 8th 05 02:40 AM
formula for dates pascot Excel Discussion (Misc queries) 1 June 21st 05 08:33 AM


All times are GMT +1. The time now is 06:00 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"