working out a date for a fixed day of the week

G

Guest

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
 
B

Bob Phillips

=A2-WEEKDAY(A2,2)+1

--
HTH

Bob

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

JE McGimpsey

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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Working Days of Week and DUE DATE for PAYMENT 4
Comparison of columns using Conditional Formatting 3
setting the date to monday 2
Excel Forecasting Dates Out to the Day 3
Calculate End Date Using Start Date and No. of Days excluding specific days. 0
Week count 2
Convert Month, Week, Year to date 2
Week Ended Friday 4

Top