Negative Dates in Excel?

Reply Subscribe

Thread Tools

Search this Thread

05 November 2002, 03:22 PM

Nimbus

Scooby Regular

Thread Starter

Join Date: Jun 2000

Posts: 4,413

Likes: 0

Received 0 Likes on 0 Posts

I need to display negative dates in an Excel spread sheet (as a differance between two other dates) but I can not find a format that will show this. Can it be done?

Cheers

Reply Like

05 November 2002, 03:29 PM

beemerboy

Scooby Regular

Join Date: Sep 2002

Location: Essexville

Posts: 4,391

Likes: 0

Received 0 Likes on 0 Posts

Nimbus, you can format 2 cells as dates, then apply a formula to a third cell as numeric and apply a formula.

ie =date1-date2 will give you number of days, then you can apply a formula to get days/hoyurs/mins if required.

I think!!! - been a while!!!

BB