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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Automatically calculate days between dates
Like:
=Day(Today()) ? -- Charles Chickering "A good example is twice the value of good advice." "JerryS" wrote: 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Automatically calculate days between dates
If you want to specify a particular month something like this might work:
=Min(30,Today()-A1) Where A1 holds the date of the first day of a month. -- Charles Chickering "A good example is twice the value of good advice." "JerryS" wrote: 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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Automatically calculate days between dates
Thanks Charles! The first version does exactly what I needed. I appreciate
your help. -- JerryS "Charles Chickering" wrote: Like: =Day(Today()) ? -- Charles Chickering "A good example is twice the value of good advice." "JerryS" wrote: 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 |
Reply |
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 |