Finding a Date 90 days previous to present date

V

Vinod

Pls help me in executing a date 90 days before a present date.
eg:Format of the file

Present Date days before previous date
15/06/2009 90 ?

Hope you understood my question.
 
S

Sam Wilson

If you want the date to go in cell C2 the formula would be:

=A2-B2

Then check that the cell is formatted as a date.
 

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

Countdown macro - display settings 2
Space at end of multi page list to accommodate new entries 1
Using formula to find out a Date 90 prior to a particular date 2
How to use/create code in MS Word to calculate age? 0
Display weeks from a Milestone 0
How to change date format to 7 working days a week in ms project 2010? 0
Date Reminder 2
Doughnut Chart linked with the slicer in the pivot table 0

Top