| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula to subtract 60 days from a date (05/25/2010) 2003excel
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! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| is there a formula that will subtract todays date from a hire date | Excel Worksheet Functions | |||
| Subtract 3 days from Date with a Twist Q | Excel Worksheet Functions | |||
| How do I subtract/add a known number of days/months from a date? | Excel Worksheet Functions | |||
| Subtract # of days from date, but if not sat, goto previous sat? | Excel Discussion (Misc queries) | |||
| excel formula that can subtract days | Excel Worksheet Functions | |||
Threaded Mode
