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