 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / September 2006If statement with dates
I'm using Excel2003 with sp2. I want to track expiration dates of memberships I want to say: If m3 is blank make N3 blank and if M3 has a date, make N3 one year later. How do I do this? Thanks in advance, Vivian Enter this formula in N3: =IF(ISNUMBER(M3),DATE(YEAR(M3)+1,MONTH(M3),DAY(M3)),"") Biff > I'm using Excel2003 with sp2. I want to track expiration dates of > memberships [quoted text clipped - 7 lines] > Thanks in advance, > Vivian This works great for incrementing the dates. I either don't know how to read the formula or it doesn't address the issue of M3 being blank then making N3 blank. I would like the formula to include either/or. Maybe it would be better if I said, If M3 is blank then make N3 blank OR if M3 has a date make N3 one year later. > Enter this formula in N3: > [quoted text clipped - 13 lines] > > Thanks in advance, > > Vivian The formula is testing cell M3 to see if it has a true Excel date. That's what: =IF(ISNUMBER(M3) is doing. True Excel dates are just numbers formatted to look like a date. If you're having problems it may be due to not having a true Excel date but a TEXT string that looks like a date. What are ALL of the possible types of entries that can be in cell M3? Just a date or left empty? No TEXT entries, right? If that's the case the formula should work if the cell contains a true Excel date. Test the "date" and make sure it's a real date: =ISNUMBER(M3) should return TRUE. Biff > This works great for incrementing the dates. I either don't know how to > read [quoted text clipped - 23 lines] >> > Thanks in advance, >> > Vivian Thanks,Biff. I got it to work and it's fine now. Vivian > The formula is testing cell M3 to see if it has a true Excel date. That's > what: [quoted text clipped - 42 lines] > >> > Thanks in advance, > >> > Vivian Good deal! Biff > Thanks,Biff. I got it to work and it's fine now. > Vivian [quoted text clipped - 52 lines] >> >> > Thanks in advance, >> >> > Vivian |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.