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.
thanks
SpetsNaz from Norway


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

Hi SpetsNaz:
The formula:
=DATE(YEAR(TODAY()),MONTH(TODAY())+1,1)-1
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.
HTH

Yogi Anand
ANAND Enterprises www.handtech.com/anand