Last day of month - how do you do it? (1 Viewer)

[EdFred]

I need to return the last date of the month not for this month, but 6 months down the road. When the FAA says 6 calendar months from a certain date it would mean go 6 months forward and then to the end of the month. So with today being April 11th, I would count 6 months forward to October, and then to the end of the month - October 31. Which would be the date I wish to return. I didn't see anything as far as formatting goes that would allow it to be done easily, and I've already attacked it two different ways, but I am wondering how you might solve the problem.

No rush in this. And I'm going to choke myself if I missed something very simple somewhere.

 

[pbaldy]

Numerous date functions here, which can be adapted to your needs (hint: pass 6 months from today instead of today).

http://support.microsoft.com/default.aspx?scid=kb;en-us;210604

 

[EdFred]

Numerous date functions here, which can be adapted to your needs (hint: pass 6 months from today instead of today).

http://support.microsoft.com/default.aspx?scid=kb;en-us;210604

Well that's certainly a lot simpler than what I did.