Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date Function
Hello Friends
I am having trouble with the date function. I wish to calculate the days between a period with the closing date as 31-Dec-07 in Column B. Case 1 Therefore if the date in column A is before 01-Jan-07, the result that I want to get in Column C (i.e. Column B - Column A) = 365 (days) Case 2 Now if the date in column A is say 01-Oct-07, the result that I want to get in Column C (i.e. 31-Dec-07 less 01-Oct-07) = 92 (days) Case 3 Now if the date in column A is say 01-Jan-07, the result that I want to get in Column C (i.e. 31-Dec-07 less 01-Jan-07) = 365 (days) Appreciate a formula or some advice on how to get it done. Thanks in advance. AJ |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date Function
Friends
Please disregard this question, after many attemps, I got it! Sorry about any inconvenience caused. AJ "AJ" wrote: Hello Friends I am having trouble with the date function. I wish to calculate the days between a period with the closing date as 31-Dec-07 in Column B. Case 1 Therefore if the date in column A is before 01-Jan-07, the result that I want to get in Column C (i.e. Column B - Column A) = 365 (days) Case 2 Now if the date in column A is say 01-Oct-07, the result that I want to get in Column C (i.e. 31-Dec-07 less 01-Oct-07) = 92 (days) Case 3 Now if the date in column A is say 01-Jan-07, the result that I want to get in Column C (i.e. 31-Dec-07 less 01-Jan-07) = 365 (days) Appreciate a formula or some advice on how to get it done. Thanks in advance. AJ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date function in ACCRINTM requires date format not available | Excel Worksheet Functions | |||
MAX figure within a date range as a function of today()'s date | Excel Worksheet Functions | |||
SUMIF within date range as a function of today()'s date | Excel Worksheet Functions | |||
Date Function formula that will return the date of a specific week | Excel Worksheet Functions | |||
Calculating days between current date and a date in future NETWORKDAYS() function | Excel Worksheet Functions |