a formula that returns the previous fridays date

[diggyroo]

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

 

[pdberger]

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

 

[Sandy Mann]

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[Billy Liddel]

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

 

[Ron Rosenfeld]

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

 

[Ron Rosenfeld]

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

 

[Ron Rosenfeld]

=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

 

[Ron Rosenfeld]

=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