| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need Date Formula Help
This formula is supposed to subtract one day every day. It works perfectly to
30 days, and then on the 31st day, it resets to zero. It needs to go indefinitely, and I'm at a complete loss. Any suggestions? =R19-DATE(YEAR(R19),MONTH(R19)-IF(DAY(R19)<DAY(L19),1,0),DAY(L19))&"days" Excel 2003 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula to look at current date and markdown date to give price | Excel Discussion (Misc queries) | |||
| Create a formula in a date range to locate a specific date - ecel | Excel Discussion (Misc queries) | |||
| Excel Formula to calulate number of days passed from date to date | Excel Discussion (Misc queries) | |||
| Formula for determining if two date columns fall within specific date range | Excel Worksheet Functions | |||
| Formula for determining if two date columns fall within specific date range | Excel Discussion (Misc queries) | |||
Threaded Mode
