Aging from a specific date in Excel

[amaready]

I'm trying to age data from a specific date such as 8/23/14 and not Today. I'm sure there is a simple formula but haven't been able to figure it out.
I've used =TODAY()-cell but what would give me aging from a specific date that is not today.

Thanks for any help!

[Special-K]

=date-cell

[daddylonglegs]

If you want the number of days them you can use DATE function, e.g

=A1-DATE(2014,8,23)

where you have a date in A1 (assumes that A1 is later than 23rd August)

format result cell as number

[amaready]

All dates are prior to August 23rd.

[amaready]

If you want the number of days them you can use DATE function, e.g

=A1-DATE(2014,8,23)

where you have a date in A1 (assumes that A1 is later than 23rd August)

format result cell as number

All dates are prior to August 23rd. So then could I use =DATE)2014,8,23)-A1 Would that give me the age as of 8/23/14?

[daddylonglegs]

Yes, that will give you the number of days

[amaready]

Thanks so much

[Vikas_Gautam]

Additionally..
After deducting a date from date..
You can use CTRL + SHIFT + Tidle (~) to change the Cell in Date format to Number format ..
to avoid any confusion..