excel formula that can subtract days

G

Gofer

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,
 
J

JE McGimpsey

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.
 
Top