| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Automatically calculate days between dates
This may be simple but I can't figure it out. I want to see a number each
time I open a particular spreadsheet that is calculated based on the number of days that have passed from the first day of the month. I don't want to have to enter todays date, that should be automatic. Since today is the 9th, I want a value of 9 calculated so I can use it in other formulas. In addition, once the number of days has reached 30, I want the calculation for that month to stop. An ideas? Thanks -- JerryS |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| need help with formula | Excel Discussion (Misc queries) | |||
| Calculating number of days between two dates that fall between two other dates | Excel Discussion (Misc queries) | |||
| Formula to calculate number of days between Dates | Excel Worksheet Functions | |||
| Calculate number of days in a column of dates | Excel Discussion (Misc queries) | |||
| How do I calculate difference in days & hours between two dates e. | Excel Worksheet Functions | |||
Threaded Mode
