![]() |
#4
|
||||
|
||||
![]()
The formula I posted will work fine for whatever the current year is - you don't need separate fields to determine whether the year is a leap year. using that formula for building calendars for different years, you could either:
• delete {SET Yr {DATE \@ YYYY}} and change all the Yr references to UserYear; or • change {SET Yr {DATE \@ YYYY}} to {SET Yr UserYear} Similarly, depending on how you're determining that the month being worked with is February, you could change or delete the {SET Mo {DATE \@ M}} and *(Mo=2) parts of the formula.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
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 |