Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date the input, then tell if over 7th off month
Hello, Can some one tell me how would I have a date appear in column A1 when any number/data is input in column B1 and so on down the column, and have like A5 tell me if any A1;A2;A3;A4 has a day past the 7th day of any date? I don't need a year to display if it matters. Thank You -- mario ------------------------------------------------------------------------ mario's Profile: http://www.excelforum.com/member.php...o&userid=31116 View this thread: http://www.excelforum.com/showthread...hreadid=508997 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date the input, then tell if over 7th off month
If you mean to have each A-cell flag each B-cell for the 7th day of
any month, then in A1 copied down =IF(DAY(B1)7,"After the 7th',"") |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date the input, then tell if over 7th off month
That does work, but here's what I'm doing, what I'm looking at right now on my test page. Every entry will contain a numeral input one for Auto and one for Manual, for example in D5 & D6 (0 to 999) In C5 & C6 I have these formulas =IF(D50,NOW(),"") & =IF(D60,NOW(),"") *Problem 1)* is if the entry is a 0 it doesn't date due to 0, I need to count the 0 as well OK that's one Now in C7 I have =IF(DAY(C6)7,"After the 7th","100%") which only monitors C6. *Problem 2)* I'd like it to populate with "After the 7th" if either C5 or C6 dates after the seventh, and "100%" should they both be on schedule before the 7th. A compare thing. Heh, this works, did a cool conditional format that shades C7 Green or Red depending on, ya know before or after - "After the 7th" or "100%". -- mario ------------------------------------------------------------------------ mario's Profile: http://www.excelforum.com/member.php...o&userid=31116 View this thread: http://www.excelforum.com/showthread...hreadid=508997 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date the input, then tell if over 7th off month
Col=C Col=D
Row=5 7-Feb-06 0 Row=6 7-Feb-06 999 Row=7 100% Formulas: C5: =IF(D5=0,TODAY(),"") C6: =IF(D6=0,TODAY(),"") C7: =IF((DAY(C5)<=7)*(DAY(C6)<=7),"100%","After the 7th") Is this it? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date the input, then tell if over 7th off month
Works great sept' 1 last issue The dates in C show now no matter what, I need the date to occur only once 0-999 has been input in the D cells Thanks so much Mario -- mario ------------------------------------------------------------------------ mario's Profile: http://www.excelforum.com/member.php...o&userid=31116 View this thread: http://www.excelforum.com/showthread...hreadid=508997 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date the input, then tell if over 7th off month
Change C5 to: =IF(LEN(D5),TODAY(),"")
and copy to C6. |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date the input, then tell if over 7th off month
Change C5 to: =IF(LEN(D5),TODAY(),"")
Copy C5 to C6 Change C7 to: =IF(LEN(C5)*LEN(C6),IF((DAY(C5)<=7)*(DAY(C6)<=7)," 100%",IF(LEN(C5)+LEN(C6),"After the 7th","")),"") |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date the input, then tell if over 7th off month
Thanks for your patience, it works. -- mario ------------------------------------------------------------------------ mario's Profile: http://www.excelforum.com/member.php...o&userid=31116 View this thread: http://www.excelforum.com/showthread...hreadid=508997 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Month to date sales - reset in new month??? | Excel Worksheet Functions | |||
extract the month of a date | Excel Discussion (Misc queries) | |||
Formula to get 1st,2nd,3rd,4th,5th Sundays from month end date. | Excel Discussion (Misc queries) | |||
HELP with this function | Excel Worksheet Functions | |||
How do I make a cell date specific to input a value on a specific. | Excel Discussion (Misc queries) |