Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have nothing in range AS2:AS10
I have some random dates in range AV2:BB:10 What I want to do is, check the difference between the two dates AW2-AV2 and keep it in memory, then check difference of AX2-AW2, keep it in memory... do this till BB2-BA2 and whichever number is highest in the memory, put in it cell AS2. Continue the same thing till row 10. Also whatever is the difference of the last dates (BB2-BA1), put it in cell AT2..... do this till row 10. Maxi |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
adding differences between dates | Excel Discussion (Misc queries) | |||
Differences between Dates | Excel Worksheet Functions | |||
Calculating time differences across two (or more) dates | Excel Discussion (Misc queries) | |||
Calculating differences in dates | Excel Discussion (Misc queries) | |||
Calculating differences between dates | Excel Worksheet Functions |