writing equations for calculating dates

G

Guest

How does one write an equation to calculate weeks
remaining prior to a set date?

For example, if there are 16 weeks before a set date, how
is the formula written to subtract today's date from the
set future date of an event with the weeks remaining to
appear in the cells? Hope this makes sense and that is a
simple task. Let me know.
 
M

Michael Malinsky

If you have a future date of 9/1/04 in Cell A1, then use the following to
determine the number of weeks remaining until that future date:

=(A1-TODAY())/7

--
Michael J. Malinsky
Pittsburgh, PA

"I am a bear of very little brain, and long
words bother me." -- AA Milne, Winne the Pooh
 
W

wennerberg

The method to do this depends upon how you define "weeks remaining."
Are you wanting FULL weeks? If it is 3.5 weeks remaining, what do yo
want displayed?
Also,
To get weeks with decimal it's simple:
=(A2-B1)/7
If your arithmetic can yield negative date arithmetic:
=ABS((A2-B1)/7
 
Top