Populate sheet with Day, month, year, qtr, period, week

[Venkatraman]

How do i populate sheet with Date, Day, Week, Month, Year, Qtr, Period from 2000 to 2015.

Please advise,

Thanks again

 

[PaddyD]

1) enter 01/01/2000 in a cell, eg a1
2) copy down to row 5479
3) day is returned by:

=text(a1,"ddd")

4) week is returned by:

=weeknum(a1)

5) month is returned by:

=month(a1)

6) quarter is returned by:

=roundup(month(a1)/3,0)

7) i have no idea what you mean by 'period'

 

[NateO]

I will lock this. It seems to be an Access question posed in the Access forum, and the Excel forum, where it does not belong with respect to the latter.

http://www.mrexcel.com/board2/viewtopic.php?t=58153

No hard feelings on my end. Send a moderator (myself included) a P.M. if I have miss-identified your post.