formula for last Fridays date
 

Hi

I am looking to setup a formula that looks at the current date & from that,
calculates & presents the previous fridays date in a cell

Can anyone advise me a formula for this?
--
TIA

Pete

formula for last Fridays date
 

Try this:

=TODAY()-WEEKDAY(TODAY()+1)

Biff

"Pete" wrote in message
...
Hi

I am looking to setup a formula that looks at the current date & from
that,
calculates & presents the previous fridays date in a cell

Can anyone advise me a formula for this?
--
TIA

Pete

formula for last Fridays date
 

Assuming "previous friday" applies to fridays, too, one way:

=A1-WEEKDAY(A1+1)


In article ,
Pete wrote:

I am looking to setup a formula that looks at the current date & from that,
calculates & presents the previous fridays date in a cell

Can anyone advise me a formula for this?

formula for last Fridays date
 

Hi Biff

Thanks for your prompt reply! - your formula works well.
--
Pete


"T. Valko" wrote:

Try this:

=TODAY()-WEEKDAY(TODAY()+1)

Biff

"Pete" wrote in message
...
Hi

I am looking to setup a formula that looks at the current date & from
that,
calculates & presents the previous fridays date in a cell

Can anyone advise me a formula for this?
--
TIA

Pete

formula for last Fridays date
 

Hi JE McGimpsey

Thanks for your prompt reply!

Ive probably done something wrong but I couldn't get your formula to work...??
--


Pete


"JE McGimpsey" wrote:

Assuming "previous friday" applies to fridays, too, one way:

=A1-WEEKDAY(A1+1)


In article ,
Pete wrote:

I am looking to setup a formula that looks at the current date & from that,
calculates & presents the previous fridays date in a cell

Can anyone advise me a formula for this?

formula for last Fridays date
 

Hi Pete

JE's formula is identical to Biff's in concept and would produce exactly
the same result if A1 held Today's date.

--
Regards

Roger Govier


"Pete" wrote in message
...
Hi JE McGimpsey

Thanks for your prompt reply!

Ive probably done something wrong but I couldn't get your formula to
work...??
--


Pete


"JE McGimpsey" wrote:

Assuming "previous friday" applies to fridays, too, one way:

=A1-WEEKDAY(A1+1)


In article ,
Pete wrote:

I am looking to setup a formula that looks at the current date &
from that,
calculates & presents the previous fridays date in a cell

Can anyone advise me a formula for this?

formula for last Fridays date
 

Your welcome. Thanks for the feedback!

Biff

"Pete" wrote in message
...
Hi Biff

Thanks for your prompt reply! - your formula works well.
--
Pete


"T. Valko" wrote:

Try this:

=TODAY()-WEEKDAY(TODAY()+1)

Biff

"Pete" wrote in message
...
Hi

I am looking to setup a formula that looks at the current date & from
that,
calculates & presents the previous fridays date in a cell

Can anyone advise me a formula for this?
--
TIA

Pete