working out a date for a fixed day of the week
 

Hi
Hope you can help.
I need a formula (is is conditional formatting?) that calculates the date
of the preceding Monday from a subsequent known date of delivery.

For example:
delivery is need for Friday 30th Nov 2007. What is the date of the preceding
Monday?
thanks Matt

working out a date for a fixed day of the week
 

=A2-WEEKDAY(A2,2)+1

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Matt Sharman" wrote in message
...
Hi
Hope you can help.
I need a formula (is is conditional formatting?) that calculates the date
of the preceding Monday from a subsequent known date of delivery.

For example:
delivery is need for Friday 30th Nov 2007. What is the date of the
preceding
Monday?
thanks Matt

working out a date for a fixed day of the week
 

=A1-MOD(A1-2,7)

"Matt Sharman" wrote:

Hi
Hope you can help.
I need a formula (is is conditional formatting?) that calculates the date
of the preceding Monday from a subsequent known date of delivery.

For example:
delivery is need for Friday 30th Nov 2007. What is the date of the preceding
Monday?
thanks Matt

working out a date for a fixed day of the week
 

Careful - this returns an erroneous date if the user is using the 1904
Date system.

Better: =A1+1-WEEKDAY(A1,2)

In article ,
Teethless mama wrote:

=A1-MOD(A1-2,7)

"Matt Sharman" wrote:

Hi
Hope you can help.
I need a formula (is is conditional formatting?) that calculates the date
of the preceding Monday from a subsequent known date of delivery.

For example:
delivery is need for Friday 30th Nov 2007. What is the date of the
preceding
Monday?
thanks Matt

working out a date for a fixed day of the week
 

Thanks Guys. Fantastic response. Great help!
--
Director of Cantifix of London Limited


"Matt Sharman" wrote:

Hi
Hope you can help.
I need a formula (is is conditional formatting?) that calculates the date
of the preceding Monday from a subsequent known date of delivery.

For example:
delivery is need for Friday 30th Nov 2007. What is the date of the preceding
Monday?
thanks Matt