showing negative numbers

  • Thread starter Thread starter dzeitler
  • Start date Start date
D

dzeitler

I am using this formula to show the amout of days between two dates.
=datedif(today(),a2,"d") this works well as long as the date in cel
A2 is in the future. If todays date is after the the date in cell A
It wont show the days as a negative number as I want it to. insted th
cell shows this. #NUM! can anyone help with this. Thank
 

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

negative dates 3
Expanding Date formula 1
Negative return in =DATEDIF function 4
changed DOB to age, but if no DOB need cell to be empty. 4
Count until condition is met and then retain final count 2
Date shows as a number 1
Calculating time between mulitple dates 4
Microsoft Query is changing a negative number into a date 1

Back
Top