Thread
:
Question regarding dates
View Single Post
#
6
Posted to microsoft.public.excel.worksheet.functions
Spiky
external usenet poster
Posts: 622
Question regarding dates
Funny what an adult beverage will do :-(
Should be
=A1-DAY(A1)+33-DAY(A1-DAY(A1)+32)
but now it's longer than the DATE function.
=DATE(YEAR(A1),MONTH(A1)+1,1)
<sigh
--ron
If shorter is better, what about....
=EOMONTH(A1,0)+1
Reply With Quote
Spiky
View Public Profile
Find all posts by Spiky