I have a workbook with worksheets for each day of the month. I need to subtract one day to = equal number of days left in the month. Ex(May 1st there are 31 days left in month, May 2nd, worksheet two, there are 30 days left in the month, and so on and so forth.) Is there a way to have these days auto fill? Thanks for your help. Todd

The simplicity or complexity of the formula would rely a lot on your workbook layout itself. Can you post up a good example workbook and make sure it is evident where you want these "days" left to appear on each sheet.

Click GO ADVANCED and use the paperclip icon to post up your workbook.