![]() |
#2
|
||||
|
||||
![]()
To do the leap year calculation correctly, you'll need a field coded like:
{QUOTE{SET Yr {DATE \@ YYYY}}{SET Mo {DATE \@ M}}{=({=G8}=28)*((MOD(Yr,4)=0)+(MOD(Yr,400)=0)-(MOD(Yr,100)=0))*(Mo=2)*29 \# 0;;}} In the above, '*' functions as an AND condition and '+' functions as an OR condition. To see how to do just about everything else you might want to do with dates in Word, check out my Microsoft Word Date Calculation Tutorial, at: http://windowssecrets.com/forums/sho...ation-Tutorial or http://www.gmayor.com/downloads.htm#Third_party Do read the document's introductory material.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
Tags |
formula, table |
Thread Tools | |
Display Modes | |
|
![]() |
||||
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 |