| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting days from a date
in cell D5 I have the date 2/12/10...in cell D6 is blank but is assumed to be
today's date...in cell D7 I need it to calculate the number of days from 2/12 to today. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Counting days from a date
Try this...
=TODAY()-D5 -- Biff Microsoft Excel MVP "Sunshine" wrote in message ... in cell D5 I have the date 2/12/10...in cell D6 is blank but is assumed to be today's date...in cell D7 I need it to calculate the number of days from 2/12 to today. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Counting days from a date
I need it to stop counting the days from D5 when I put an end date in D6
"T. Valko" wrote: Try this... =TODAY()-D5 -- Biff Microsoft Excel MVP "Sunshine" wrote in message ... in cell D5 I have the date 2/12/10...in cell D6 is blank but is assumed to be today's date...in cell D7 I need it to calculate the number of days from 2/12 to today. . |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Counting days from a date
Try this...
=IF(D6="",TODAY(),D6)-D5 -- Biff Microsoft Excel MVP "Sunshine" wrote in message ... I need it to stop counting the days from D5 when I put an end date in D6 "T. Valko" wrote: Try this... =TODAY()-D5 -- Biff Microsoft Excel MVP "Sunshine" wrote in message ... in cell D5 I have the date 2/12/10...in cell D6 is blank but is assumed to be today's date...in cell D7 I need it to calculate the number of days from 2/12 to today. . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting no of days of a specific range of days from a list | Excel Discussion (Misc queries) | |||
| Need to pull <=14 Days, <=30 Days, 30 Days from a date column | Excel Discussion (Misc queries) | |||
| Counting Days of Week in Date Ranges | Excel Worksheet Functions | |||
| Counting 45 days from a certain date | Excel Discussion (Misc queries) | |||
| Conditional Formatting Dates calculating 10 days and 30 days from a certain date | Excel Worksheet Functions | |||
Linear Mode
