MrExcel Publishing
Your One Stop for Excel Tips & Solutions

A formula that will change each month!

Posted by SpetsNaz on February 10, 2002 3:31 PM

I have made this excelsheet where i need to get data from the last three months. this means i need to have a formula that changes the last day every month.
maybe i can solve this using a macro?! looking forward to get some good tips.
SpetsNaz from Norway

Posted by Yogi Anand on February 10, 2002 7:53 PM

Hi SpetsNaz:
The formula:
will give you last day of the current month and the current year. I hope this is what you were looking for. Please post whether it works for you.

Yogi Anand
ANAND Enterprises