Home |
Search |
Today's Posts |
#1
|
|||
|
|||
excel formula that can subtract days
I am trying to put in a formula that will go to a target date, add 12 months
but be the last day of the month. I tried going plus 13 months minus the pointed to day of the month minus one more day. Any help would be appreciated. Thanks, |
#2
|
|||
|
|||
try
=DATE(YEAR(H1)+1,MONTH(H1)+1,1-1) -- Don Guillett SalesAid Software "Gofer" wrote in message ... I am trying to put in a formula that will go to a target date, add 12 months but be the last day of the month. I tried going plus 13 months minus the pointed to day of the month minus one more day. Any help would be appreciated. Thanks, |
#3
|
|||
|
|||
Or, with two fewer operations <g:
=DATE(YEAR(A1),MONTH(A1)+13,0) The zeroth day of the month, to XL, is the last day of the previous month. In article , "Don Guillett" wrote: =DATE(YEAR(H1)+1,MONTH(H1)+1,1-1) |
#4
|
|||
|
|||
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Calculating Production/Man Days in Excel | Excel Discussion (Misc queries) | |||
Converting an Excel formula to an Access query formula | Excel Discussion (Misc queries) | |||
Suddenly Excel can't calculate formula!!! | Excel Worksheet Functions | |||
Excel 2003 - Formula result shows as 0:00 | Excel Worksheet Functions |