I need help making a formula calculating 90 days before a certain date, i.e. if something is due on Aug 31st, 2012, how do i make a formula showing 1st submission due 90 days earlier, i.e. May 31st, 2012? Thanks

First, a posting tip: When you post a question in a help forum such as computing.net, please use a subject line that tells us something about your post.

If everyone used a generic subject line such as

Excel Formula, we wouldn't be able to tell one question from another.I have edited the subject line of this thread.

As far as your question...

With your date is A1, it's as simple as =A1-90

DerbyDad03

Office Forum Moderator

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Ask Your Question

Weekly Poll