dates

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using A1-TODAY() to get a count down on the days remaining between two
date .
But when i enter the dates in a1 ...any date like 1/1/08 it tells me that
"The date you entered is before the current date .you must enter a date after
today"
what give????
OPn6
 
Excel has probably automatically formatted the cell with the formula in it as
a date, and it hates negative dates. Try formatting the cell as General.
 
Do you have Data Validation for A1? Have you checked the settings?
 
You must log in or register to reply here.

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

Excel Date Count 2
Excel Message box with days of month & date. 1
formula to subtract 60 days from a date (05/25/2010) 2003excel 3
Function to Return a Date Value Q 4
Excel Vba to change displayed year automatically. 14
formulas to count dates 2
Access Property sheet data missing also syntax 0
conditional formating with dates 1

Back
Top