![]() |
#3
|
|||
|
|||
![]()
Interesting...
I always find strange ways of doing things. I determined leap year using the following method (items are bookmarked): UserYear = 2016 (or any year the user inputs) Leap1 = 1/29/UserYear Leap2 = { If {Leap1 \@ MMMM } = "February" 1 0 } So, maybe something like the following should work? { IF {=G8 } >= 31 { IF { { =G8 } =28 }*{ { =Leap2 } = 1} 29 "" } {IF { =G8 } ≠ 0 { =G8+1 } "" }} Or maybe? { IF {({ =G8})*({ =Leap2})} =28 29 "" } For some reason, I can't seem to get this to work. It always produces a 29 result; it appears as though =28 is an answer rather than a qualifier. "≠" because I couldn't use greater/less than symbols in forum. That said, I'll look at what you've provided. I can see that it does the most comprehensive check. I'm just not confident in my ability to incorporate it properly. Thanks! Last edited by Scrapyard; 01-25-2014 at 04:50 AM. Reason: Another Attempt |
Tags |
formula, table |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Excel Formulas | barryjones | Excel | 2 | 06-03-2013 04:27 AM |
Need help with formulas please | paul_pearson | Excel | 0 | 03-20-2013 06:51 AM |
![]() |
ninfanger | Excel | 3 | 10-23-2010 12:29 AM |
![]() |
mizzamzz | Excel | 1 | 07-08-2010 02:32 AM |
Table formulas | markg2 | Word Tables | 0 | 01-15-2010 06:49 AM |