![]() |
#10
|
||||
|
||||
![]()
In F3, try:
=TEXT(DATE(YEAR(TODAY()),MONTH(TODAY())+MOD(DATEDI F(DATE(YEAR(TODAY()),MONTH(TODAY()),1),DATE(YEAR(T ODAY())+1,MONTH(DATEVALUE("1-"&$E3&"-"&YEAR(TODAY())))+1,0),"ym"),(12/2^($D3-1))),1),"MMM") then copy down as far as needed. PS: As previously advised, the board software puts spaces in the formula where there shouldn't be any. In this case, 'DATEFI F' is 'DATEDIF' and 'T ODAY()' is 'TODAY()' Note: If you change the cell format, to 'mmm', you could reduce the formula to: =DATE(YEAR(TODAY()),MONTH(TODAY())+MOD(DATEDIF(DAT E(YEAR(TODAY()),MONTH(TODAY()),1),DATE(YEAR(TODAY( ))+1,MONTH(DATEVALUE("1-"&$E3&"-"&YEAR(TODAY())))+1,0),"ym"),(12/2^($D3-1))),1)
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
Thread Tools | |
Display Modes | |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
chedlee | Mail Merge | 1 | 03-07-2014 12:29 AM |
Complicated Formula Needed | midgetmogalle | Excel | 14 | 01-29-2014 10:26 AM |
help with complicated formula | flyinghigher2011 | Excel | 6 | 07-30-2013 02:16 PM |
![]() |
steveman1234 | Word Tables | 2 | 03-28-2010 06:20 PM |
Using calculated field - WHY IS IT SO COMPLICATED? | Riorin | Word | 0 | 10-30-2009 12:20 PM |