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.


--
Regards
Dave Hawley
www.ozgrid.com
"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!

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

--
Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------


"HH" wrote:

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!

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!