week entry

A

aditya

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

week entry 1
week entry new 3
simple week entry 2
Financial Year Weeknum 2
Formula IF 1
Week Number Format 4
Still trying to average 4 worksheets and having formula problems 3
Populate year, month and quarter from entered date 2

Top