Thread: [Solved] How to set month+1 and horizontal line
View Single Post
 
Old 03-25-2013, 01:14 AM
nightkn8 nightkn8 is offline Windows XP Office 2010 32bit
Novice
  
Join Date: Mar 2013
Posts: 12
nightkn8 is on a distinguished road
Default
I'm getting january with this formula. Any change that I do in it causes january return.
ex
{QUOTE "{=MOD({DATE \@ M},12)+1}/1/00" \@ "MMMM"}
{QUOTE "{=MOD({DATE \@ M},12)+2}/1/00" \@ "MMMM"}
{QUOTE "{=MOD({DATE \@ M},12)+2}/2/00" \@ "MMMM"}
all above will give january
Reply With Quote