Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Return Days since Date Entered in Column.
I have a worksheet with a column containing dates ('A'). I want to keep a running total of how many days (for example: '180' from the date in column A. I noticed if I simply subtract the date from todays date, the valu returned is formated as a date. I want just the days rolling (180) instead somethign like this '01/30/1900' which I tend to end up with. Any suggestions? Someone earlier suggested NETWORKDAYS(a1-b1). but it didnt seem t work. Mik -- Mcastee ----------------------------------------------------------------------- Mcasteel's Profile: http://www.excelforum.com/member.php...fo&userid=1569 View this thread: http://www.excelforum.com/showthread.php?threadid=31494 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Return Days since Date Entered in Column.
Hi Mcasteel
Select the formula cell and goto FormatCells and format the cell as General -- Regards Ron de Bruin http://www.rondebruin.nl "Mcasteel" wrote in message ... I have a worksheet with a column containing dates ('A'). I want to keep a running total of how many days (for example: '180') from the date in column A. I noticed if I simply subtract the date from todays date, the value returned is formated as a date. I want just the days rolling (180), instead somethign like this '01/30/1900' which I tend to end up with. Any suggestions? Someone earlier suggested NETWORKDAYS(a1-b1). but it didnt seem to work. Mike -- Mcasteel ------------------------------------------------------------------------ Mcasteel's Profile: http://www.excelforum.com/member.php...o&userid=15698 View this thread: http://www.excelforum.com/showthread...hreadid=314940 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Return Days since Date Entered in Column.
change the format??
-- Don Guillett SalesAid Software "Mcasteel" wrote in message ... I have a worksheet with a column containing dates ('A'). I want to keep a running total of how many days (for example: '180') from the date in column A. I noticed if I simply subtract the date from todays date, the value returned is formated as a date. I want just the days rolling (180), instead somethign like this '01/30/1900' which I tend to end up with. Any suggestions? Someone earlier suggested NETWORKDAYS(a1-b1). but it didnt seem to work. Mike -- Mcasteel ------------------------------------------------------------------------ Mcasteel's Profile: http://www.excelforum.com/member.php...o&userid=15698 View this thread: http://www.excelforum.com/showthread...hreadid=314940 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Return Days since Date Entered in Column.
Here is a formula that I frequently use for date variances.
=DAYS360(H4,G4) -----Original Message----- I have a worksheet with a column containing dates ('A'). I want to keep a running total of how many days (for example: '180') from the date in column A. I noticed if I simply subtract the date from todays date, the value returned is formated as a date. I want just the days rolling (180), instead somethign like this '01/30/1900' which I tend to end up with. Any suggestions? Someone earlier suggested NETWORKDAYS(a1-b1). but it didnt seem to work. Mike -- Mcasteel ---------------------------------------------------------- -------------- Mcasteel's Profile: http://www.excelforum.com/member.php? action=getinfo&userid=15698 View this thread: http://www.excelforum.com/showthread...hreadid=314940 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need to pull <=14 Days, <=30 Days, 30 Days from a date column | Excel Discussion (Misc queries) | |||
Adding entries if date entered in another column | Excel Worksheet Functions | |||
add days to a date and return resulting date | Excel Worksheet Functions | |||
If data in one column, take date, add 2 days, and turn the entire column a color... | Excel Discussion (Misc queries) | |||
Need date to appear 90 days later than initial date entered | Excel Worksheet Functions |