Month formula

The month formula takes out the month in a numerical answer (answer will anything from 1 to 12) out of a date. Make sure that you use the number format for the date and not the date format, otherwise it will not work

This works very well for analyzing of data per month.

Things you can do with the month formula

• Summarize data per month by using a pivottable...contact us for more info
• Change the day or year but use the same month...contact us for more info

<-----Back to index

Next topic----->