Auto fill weekday range in header cells????

  • Thread starter Thread starter FrankBooth
  • Start date Start date
F

FrankBooth

Hi,

I want to create a function or formula that would create the following:

|7/26 - 7/30| 8/2 - 8/6| etc...

So, each cell would have in it the start and end dates of the weekdays in the week.

Is this possible?

Thanks,
--FB
 
Hi
one way:
- in cell A1 enter the first date of the first week you are interested
in
- in A2 enter the following formula
=TEXT($A$1+7*(COLUMN()-1),"M/D") & " - " &
TEXT($A$1+6+7*(COLUMN()-1),"M/D")

and copy this to the right
 
I used a helper cell (A1) and put my starting date in it.

Then I put this in a cell in column A and dragged to the right:

=TEXT($A$1+(7*(COLUMN()-1)),"m/d")&" - "&TEXT($A$1+4+(7*(COLUMN()-1)),"m/d")
 
Back
Top