Using IF statement and dates.

Microsoft Excel 010 - complete package
April 11, 2012 at 09:53:32
Specs: Windows XP
Is there a way to have excel recognize month change using an if statement?
I am setting up monthly charts that need to vary based on the month, these charts are for a running calendar that requires calculations of three month intervals and overall totals, but they need to look pretty.
Currently I have my main page set up where they can enter the month started and have been able to get the subsequent pages to change to the proper month. I can get the dates to populate but when it comes to months that have <31 days it is showing the date for the next month.
Just for an understanding; these sheets can be started any month of the year. The quarterly results must be reported from start month to date.

See More: Using IF statement and dates.

Report •

April 11, 2012 at 10:47:20
Well thanks to any who read this! I was able to figure it out after I posted this but thought that others may have this issue, so here is the results.


The outside if statement is to cover February, if this is not done it will work on the 29th cell if it is not a leap year but result in an error on the 30th cell.

Where AL36 is the day before, G4 is the current month.

So if AL36 is the 28th of Feb, 2012, then AL36+1 would be 29-Feb-12 and it would report it out, but if AL36 is the 28th of Feb, 2011 it would be blank.

Report •
Related Solutions

Ask Question