Thread
:
excel formula that can subtract days
View Single Post
#
4
Don Guillett
Posts: n/a
Better smarty pants
--
Don Guillett
SalesAid Software
"JE McGimpsey" wrote in message
...
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)
Reply With Quote