| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula adding 2 days...
So, here is the formula I'm using. Some cells it's adding 2 or 3 days to the
MONTH and some cells it's not. I don't WANT it to add 2 days. It should just be adding 5 years and leaving the month and day the same... what is happening here? =IF(J5="","",DATE(YEAR(J5)+5,MONTH(J5),DAY(J6))) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula for adding days to a date excluding weekends and holidays? | Excel Discussion (Misc queries) | |||
| If Formula , Adding Days to a Date | Excel Discussion (Misc queries) | |||
| formula returns #VALUE! when adding days to a date | Excel Discussion (Misc queries) | |||
| Adding Working Days to a Formula | Excel Discussion (Misc queries) | |||
| What is the formula for adding a number of days to an existing dat | Excel Worksheet Functions | |||
Threaded Mode
