Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default negative dates

I'm using a simple formula to calculate the days from a start date
"=c21-today()"

I cannot reverse the formula to get a negative number.

Any tips on how to get this number to show up as "-nnn"

thanks.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
negative dates in excel Peekabeaux Excel Discussion (Misc queries) 1 August 6th 07 11:30 PM
NEGATIVE DATES IN EXCEL TJV1960 Excel Worksheet Functions 2 February 23rd 07 02:46 AM
negative dates or times are displayed as # # # # Amr Shehata Excel Worksheet Functions 4 February 2nd 07 11:35 AM
negative dates or times are displayed as # # # # Amr Shehata New Users to Excel 3 November 9th 06 12:34 PM
NEGATIVE IN BARCKETS AND UK DATES EASTCOAST Excel Discussion (Misc queries) 2 July 1st 05 01:10 PM


All times are GMT +1. The time now is 03:08 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"