Thread: week entry
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Aditya Aditya is offline
external usenet poster
 
Posts: 54
Default week entry

From a given date in a cell how can i get following things in different cell
(1) week of the month
(2)Financial year week (fiscal week)
(3) Quarter

e.g.
if A1=12 MAY 2009 , I want B1=2nd week ; C1=1st Quarter (financial year 1st
APR to 31st MAR)

or,
if A1=1 July 2008 , I want B1=1st week; C1= 2nd Quarter

Thanks in advance