Day formula

This day formula takes out the day in a numerical answer (answer will be anything from 1 to 31) 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 day.

Things you can do with the day formula

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

<-----Back to index

Next topic----->