| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How many days since....
I would like to ask for help with a formula:
If I have a date in A1 (4/10/09) and in B1 I want a formula that shows how many days has passed since that date, how would I write this formula? Thanks Jim |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How many days since....
Put following formula in B1 to subtract the date in A1 from the current
system date. =TODAY()-A1 "Jim" wrote: I would like to ask for help with a formula: If I have a date in A1 (4/10/09) and in B1 I want a formula that shows how many days has passed since that date, how would I write this formula? Thanks Jim |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How many days since....
With B1 formatted as numbers
=TODAY()-A1 will give you 7 with 4/10 in A1 You can also use =TODAY()-A1-1 if you want don't want to count today. "Jim" wrote: I would like to ask for help with a formula: If I have a date in A1 (4/10/09) and in B1 I want a formula that shows how many days has passed since that date, how would I write this formula? Thanks Jim |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Employee days worked (-Holidays, -weekends, Snow Days, etc) | Excel Discussion (Misc queries) | |||
| Calc days between two dates and exclude leap year days | Excel Worksheet Functions | |||
| Conditional Formatting Dates calculating 10 days and 30 days from a certain date | Excel Worksheet Functions | |||
| COUNT how many ROWS ago out of 10 days that the highest high in 10 days was made | Excel Worksheet Functions | |||
| Convert days in decimal to days:hours:minutes | Excel Worksheet Functions | |||
Hybrid Mode
