Sir Babydum GBE
11-23-2009, 01:45 PM
Hi again! :hi: I thought I'd be able to do this...
Suppose there is a date (dd/mm/yy) in A1 - say March 31, 2009. How do I:
1) Use a formula in B1 to return the third month (with year attached) (in this case, "May 2009" as April, being the second month, is missed)
2) In C1 use an If formula to return a "not due" if we are in April, "Due" if the current date falls within the first 14 days of May and "overdue" if the current date falls on the 15th day or later?
Not code, but using VBA tags for formatting reasons
EG1: Today's date is 23/Nov/2009
A1 B1 C1
17/09/2009 Nov 2009 Overdue
EG2: Today's date is 04/Dec/2009
A1 B1 C1
19/10/2009 Dec 2009 Due
EG: Today's date is 20/Jan/2010
A1 B1 C1
30/12/2009 Feb 2010 Not Due
Thanks
Sir BD
Suppose there is a date (dd/mm/yy) in A1 - say March 31, 2009. How do I:
1) Use a formula in B1 to return the third month (with year attached) (in this case, "May 2009" as April, being the second month, is missed)
2) In C1 use an If formula to return a "not due" if we are in April, "Due" if the current date falls within the first 14 days of May and "overdue" if the current date falls on the 15th day or later?
Not code, but using VBA tags for formatting reasons
EG1: Today's date is 23/Nov/2009
A1 B1 C1
17/09/2009 Nov 2009 Overdue
EG2: Today's date is 04/Dec/2009
A1 B1 C1
19/10/2009 Dec 2009 Due
EG: Today's date is 20/Jan/2010
A1 B1 C1
30/12/2009 Feb 2010 Not Due
Thanks
Sir BD