Formula to generate week of year (Monday through Sunday) based on a date entered

**seanpod** · 05-19-2017, 12:24 PM

I am interested in learning a formula to return the week of the year in one cell when I enter the date in a different cell.

I know =weeknum but unfortunately it returns values based on a Sunday through Saturday schedule, whereas I want a Monday through Sunday schedule.

Thanks.

**shg** · 05-19-2017, 12:30 PM

Did you look at the return_type argument for WEEKNUM?

**Logit** · 05-19-2017, 12:31 PM

=WEEKNUM(A2, 2)

Presumes your date entry is located in A2

**seanpod** · 05-19-2017, 12:38 PM

Originally Posted by Logit

=WEEKNUM(A2, 2)

Presumes your date entry is located in A2

Perfect! Thank you.

**Logit** · 05-19-2017, 12:44 PM

You are welcome.

Formula to generate week of year (Monday through Sunday) based on a date entered

LinkBack

Thread Tools

Rate This Thread

Display

Formula to generate week of year (Monday through Sunday) based on a date entered

Re: Formula to generate week of year (Monday through Sunday) based on a date entered

Re: Formula to generate week of year (Monday through Sunday) based on a date entered

Re: Formula to generate week of year (Monday through Sunday) based on a date entered

Re: Formula to generate week of year (Monday through Sunday) based on a date entered

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Need a formula that picks up the date for Monday for each week from a given month and year

Monday and Sunday of the current week

VBA - Date required for Monday & Sunday of week previous

Formula to generate date of weekday (e.g. Monday) of given week

Formula to Indicate name of day (Sunday, Monday etc..) based on a Date

Microsoft Excel : How can we get the date of the Monday of Week 44 of Year 2005?

[SOLVED] Microsoft Excel : How can we get the date of the Monday of Week 44 of Year 2005?

[SOLVED] Microsoft Excel : How can we get the date of the Monday of Week 44 of Year 2005?

Bookmarks

Bookmarks

Posting Permissions