Excel Date Function
I need a constitantly updating date function on a spreadsheet. For example,
everyday, the number I divide a certain total by depends on what day of the month it is. Like if it is the 8th of November, my total would be divided by 8. The next day, Excel would recognize that it was 9th, and automatically divide the number by nine. My question is what formula do I enter so my product cell can refer to the 'day' cell to grab the number to divide by? Any help would be great, thanks. |
Try this:
=DAY(TODAY()) "Mike" wrote: I need a constitantly updating date function on a spreadsheet. For example, everyday, the number I divide a certain total by depends on what day of the month it is. Like if it is the 8th of November, my total would be divided by 8. The next day, Excel would recognize that it was 9th, and automatically divide the number by nine. My question is what formula do I enter so my product cell can refer to the 'day' cell to grab the number to divide by? Any help would be great, thanks. |
All times are GMT +1. The time now is 03:00 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com