How to find the weekdays for a particular date both for month as well as for yea

[sdsurzh]

Hi,


How to find the weekdays for a particular date both for month as well as for year


(Ex: 01-May-12, For Month I want “1st week May”. For Year I want “18 weeks 2012”


Thanks in advance,

Suresh Kumar S

 

[Hui]

Suresh

Simply type your date into a cell eg: 1/5/2012

Then format the cell using a Custom Number format of ddd or dddd

or

=Text(A1,"dddd") where a1 has the date


I'm note sure what you mean for the second part of the question "For year I want 18 Weeks 2012"?

Is that simply =Date(2012,1,0)+18*7

 

[sdsurzh]

Hi Hui,


I want to know which week for a particular date

(Ex:In A1 cell contains "01-may-2012" and i want the output in B1 is "1st week may"


Leave it about the second part of my question.


Thanks,

Suresh Kumar S

 

[Hui]

2nd Question:

Assuming your date is in B2:

=INT((B2-EOMONTH(B2,-1)+1)/7) +1 & CHOOSE(INT((B2-EOMONTH(B2,-1)+1 )/7 )+1, "st", "nd", "rd", "th", "th") & " week " & TEXT(B2, "mmmm")

 

[kaushik03]

Hi Suresh Kumar,


I assume your date 01-may-2012 is at A1.


At B1 try this:


=IF(INT((DAY(A1)-1)/7)+1=1,"First",IF(INT((DAY(A1)-1)/7)+1=2,"Second",IF(INT((DAY(A1)-1)/7)+1=3,"Third","Fourth")))&" "&"Week"&"of"&" "&TEXT(A1,"mmm")


Change the date at A1 to test the formula


Hope this helps..


Regards,

Kaushik

 

[kaushik03]

Oopps!!!!1


Sorry Hui Sir...I did not see your reply while posting (You replied when I was working on this)..


Regards,

Kaushik

 

[sdsurzh]

Hi Hui and Kaushik03,


Thanks for your kind help.


Regards,

Suresh Kumar S