Convert regular Date to Week Ending or Week Beginning Dates

S

Sam H

I am have column with dates that I would like to stratify by either Week
Ending Dates (Fridays or Saturdays) or Week Beginning Dates (Sundays or
Mondays)
 
J

Jim Thomlinson

I am not too sure what constitutes the beginning or ending of a week so I
will stich with generalities.

There is a weekday function which returns a number from 1 to 7 corresponding
to the day of the week. So this formula will give you the first day of the
week (assuming sunday is the first day of the week)
=A1-WEEKDAY(A1)+1
Add 7 to theat for the end of the week...

If your question is something different just reply back...
 
J

Jim

I'm using this successfully, but have some cells with no data. Is there
something I can add that will leave the cell blank rather than display
#VALUE! or ###########
 
D

Dave Peterson

Maybe...

=if(a1="","",A1-WEEKDAY(A1)+1)
I'm using this successfully, but have some cells with no data. Is there
something I can add that will leave the cell blank rather than display
#VALUE! or ###########
Click to expand...
 

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

2007 Macro to Open File, Delete Contents, Save New File 2
Week Ending data 2
Creating a Search using a combo box and then creating a report. 4
Counting Days of Week 2
Returning every 7th row of a column 8
Generate list of dates for 4-week periods 1
Excel check if dates are under a range of week 4
format dates enigma 3

Top