I need a date formula that returns the date of the friday from the week
before. For example i need it to return March 07 2008 up untill March 14
2008 the it will return that untill March 28th and so on? Any help would be
greatly appreciated

Diggyroo --

This works for me. If the date is in cell A1, then B1 might be:

=A1-WEEKDAY(A1)-1

That generated 3/7 through the end of the week, then 3/14.

HTH

"diggyroo" wrote:

I need a date formula that returns the date of the friday from the week
before. For example i need it to return March 07 2008 up untill March 14
2008 the it will return that untill March 28th and so on? Any help would be
greatly appreciated

Assuming that you want the date on Friday to return that Friday's date not
the previous Friday then try:

=A1-(WEEKDAY(A1+3,2))+1

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"diggyroo" wrote in message
...
I need a date formula that returns the date of the friday from the week
before. For example i need it to return March 07 2008 up untill March 14
2008 the it will return that untill March 28th and so on? Any help would
be
greatly appreciated

I assume that you do not want to enter a date but just show Fridays date
until the next Friday. This is done with the TODAY and WEEKDAY Functions.
Just be careful with the wrapping when you copy the formula.

=IF(WEEKDAY(TODAY())6,TODAY()-WEEKDAY(TODAY())+6,IF(WEEKDAY(TODAY())<6,TODAY()-WEEKDAY(TODAY())-1,TODAY()))

Regards
Peter

"diggyroo" wrote:

I need a date formula that returns the date of the friday from the week
before. For example i need it to return March 07 2008 up untill March 14
2008 the it will return that untill March 28th and so on? Any help would be
greatly appreciated

On Wed, 12 Mar 2008 14:41:04 -0700, diggyroo
wrote:

I need a date formula that returns the date of the friday from the week
before. For example i need it to return March 07 2008 up untill March 14
2008 the it will return that untill March 28th and so on? Any help would be
greatly appreciated


=A1-WEEKDAY(A1-6)
--ron

On Wed, 12 Mar 2008 14:41:04 -0700, diggyroo
wrote:

I need a date formula that returns the date of the friday from the week
before. For example i need it to return March 07 2008 up untill March 14
2008 the it will return that untill March 28th and so on? Any help would be
greatly appreciated

Do you really want it to return Mar 14 up to Mar 28? or only to Mar 21?
--ron

On Wed, 12 Mar 2008 21:25:43 -0400, Ron Rosenfeld
wrote:

On Wed, 12 Mar 2008 14:41:04 -0700, diggyroo
wrote:

I need a date formula that returns the date of the friday from the week
before. For example i need it to return March 07 2008 up untill March 14
2008 the it will return that untill March 28th and so on? Any help would be
greatly appreciated


=A1-WEEKDAY(A1-6)
--ron

Rereading your question, I'm not sure if you want to return March 14 on March
14, or March 7 on March 14.

If the latter, my first formula will do that.

If the former, then:

=A1+1-WEEKDAY(A1-5)
--ron

On Wed, 12 Mar 2008 15:41:01 -0700, pdberger
wrote:

=A1-WEEKDAY(A1)-1

That generated 3/7 through the end of the week, then 3/14.

But he wanted 3/7 until 3/14
--ron