| Home |
| Search |
| Today's Posts |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Question
This formula using 1 April 2008 yields 31
=INT((TODAY()-DATE(2008,4,1))/7) 31.00 Using 2008,4,15 gives 29 -- Don Guillett Microsoft MVP Excel SalesAid Software "Donnas3944" wrote in message ... I have a spreadsheet that I update weekly with several formula's in it and contains several weeks of information. Each week when I go in and update it he final step is to change the number of weeks I am dividing by. Example this week was 28, next Friday I will need to divid by 29. This has to be changed in 3 locations on the SS. Is there a way I can add a fromula that I can change that will change this number in all 3 locaitons and only have to change it once. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| where can I see my question and answer? Yesterday I ask a question | Excel Discussion (Misc queries) | |||
| If Question | Excel Worksheet Functions | |||
| Newbie Question - Subtraction Formula Question | Excel Discussion (Misc queries) | |||
| question....help | Excel Discussion (Misc queries) | |||
| The question is an excel question that I need to figure out howto do in excel. | Excel Worksheet Functions | |||
Threaded Mode
