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

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!
 
O

ozgrid.com

=A1-60 works for me. What side are your "dates" aligning to? Left or Right,
should be right.
 
M

Ms-Exl-Learner

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
 
F

Fred Smith

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
 

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

Top