formula to subtract 60 days from a date (05/25/2010) 2003excel

  • Thread starter Thread starter HH
  • Start date Start date
H

HH

Would appreciate some help!! I have to enter dates and return a date 60 days
before the entered date. I am formating the date entered column as
mm/dd/yyyy.
Everything I try doesn't work. How would you format the date entered column?
There's a formula on the Internet that says it's so easy:
=A1-60, doesn't work; =DATE(YEAR(A1),MONTH(A1), DAY(A1)-60) doesn't work.
They should, so I must have my column format wrong.
Help!
 
=A1-60 works for me. What side are your "dates" aligning to? Left or Right,
should be right.
 
Check whether the A1 cell is having any leading spaces. If it is exported
from any software then sometimes the fields contains some spaces on it.

Try the below formula in B1 cell.
=VALUE(A1)-60
Or
=VALUE(TRIM(A1))-60
 
If =a1-60 doesn't work, it means your date is text. You need to convert it
to a date. You can use Text-to-columns, copy/paste special, or
=datevalue(a1). Simply changing the format won't have any effect on a text
cell. You need to change its value.

Regards,
Fred
 
Back
Top