Finding a Date 90 days previous to present date
 

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.

Finding a Date 90 days previous to present date
 

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.


"Vinod" wrote:

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.

Finding a Date 90 days previous to present date
 

With date in A1 the below formula will do.

=A1-90
(and format this to date)

If this post helps click Yes
---------------
Jacob Skaria


"Vinod" wrote:

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.