Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date problem
Hi, i have this code:
{=IF(NOT(SUMPRODUCT(--(Sheet1!A2:L2=TODAY()),--(Sheet1!A3:L3<""))),"Please pay",IF(COUNT(Sheet1!A2:L2),IF(TODAY()=MAX(Sheet1 !A2:L2),"Expired", INDEX(Sheet1!A2:L2,,MIN(IF(Sheet1!A2:L2TODAY(),CO LUMN(Sheet1!A2:L2)))-COLUMN(Sheet1!A2:L2)+1)-TODAY()),""))} This code is working good, but calculates when entire month has past. I need this code to calculate when 01.10.2009 has past. I need to calculate by days. ex: A2:L2 = dates (01.09.2009 ; 01.10.2009 ; 01.11.2009...) A3:L3 = billings number (some numbers) This code is looking for curent month in A2:L2 and if below that cell in A3:L3 finds some numbers, calculates days till next date in A2:L2. If it doesn't find numbers in A3:L3, return "please pay" What the code is doing now: J2=01.10.2009 K2=01.11.2009 L2=01.12.2009 J3= 123(some number) K3= (empty) L3= (empty) The code return "please pay" because this we are stiil in this month. If i write something in K3, then the code display "29". I need the code to calculate when the date 01.10.2009 has past. If today is 03.10.2009, then the code to display remaining days till next date if J3 has some numbers. Now, the code calculate with a month ahead i guess...i dont know. Can this be done? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Exel increment date problem wrt todays date. | Excel Worksheet Functions | |||
Date Formula Problem - Leave date blank if Null | Excel Worksheet Functions | |||
DATE PROBLEM | Excel Worksheet Functions | |||
date problem | Excel Worksheet Functions | |||
Date Problem | New Users to Excel |