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

"HH" wrote in message
...
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!