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=02 MAY 2009 , I want
B1=1st week
C1=5th week (financial year 1st APR to 31st MAR)
D1=1st Quarter

Thanks in advance