| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Dates
I would like to subtract 10 days from a date automatically on the first of
the month. How can I do that? Please speak slow, I'm new |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Dates
If cell A1 contains =TODAY() then in A2 enter:
=IF(DAY(A1)=1,A1-10,"") and format as date. -- Gary's Student "Deion007" wrote: I would like to subtract 10 days from a date automatically on the first of the month. How can I do that? Please speak slow, I'm new |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating number of days between two dates that fall between two other dates | Excel Discussion (Misc queries) | |||
| Automatic shading of cells based on dates??? | Excel Worksheet Functions | |||
| 2 digit year in dates return 19xx not 20xx | Excel Discussion (Misc queries) | |||
| Using dates for x-axis values as string instead of creating a scale | Charts and Charting in Excel | |||
| Formating Dates for production schedule | Excel Discussion (Misc queries) | |||
Linear Mode
