Home |
Search |
Today's Posts |
#1
|
|||
|
|||
CALCULATING DATES AFTER DATEIF
Is there a way to add the result of two dateIf functions. the result for eact
is like this (23 years 6 months 5 days ) can I add this from one sheet to the same kind of result from another sheet. Thanks for your help |
#2
|
|||
|
|||
To get 23 years 6 months 5 days it must be 3 datedif functions concatenated
and not one so the 2 you are talking about might in fact be 6, you can add the years, the months and the days separately -- Regards, Peo Sjoblom (No private emails please) "Glen" wrote in message ... Is there a way to add the result of two dateIf functions. the result for eact is like this (23 years 6 months 5 days ) can I add this from one sheet to the same kind of result from another sheet. Thanks for your help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating differences between dates | Excel Worksheet Functions | |||
Calculating dates | Excel Discussion (Misc queries) | |||
Calculating for number of days when values are in dates | Excel Worksheet Functions | |||
Calculating Due Dates Based on Payments | Excel Worksheet Functions | |||
Using imported Query & Calculating Dates | Excel Worksheet Functions |