charliew

Board Regular
Joined
Feb 20, 2018
Messages
60
Office Version
  1. 365
Platform
  1. Windows
I have a holiday tracker calendar and it uses macros and formulas to calculate days and dates etc.
I have this code:

=IF(AND((COLUMN()-1)>31*($A$3-1),MONTH(DATE($A$2+INT(($A$3+$A$1)/12),IF((INT((COLUMN()-1)/31.001)+$A$1)>12,(INT((COLUMN()-1)/31.001)+$A$1-12),INT((COLUMN()-1)/31.001)+$A$1),ROUNDUP(MOD(COLUMN()-1,31.001),0)))=ROUNDUP(MOD($A$1+$A$3-1,12.01),0)),ROUNDUP(MOD(COLUMN()-1,31.001),0),"")

Can i add something in there to highlight it when the date is today?

cheers
 

Some videos you may like

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

charliew

Board Regular
Joined
Feb 20, 2018
Messages
60
Office Version
  1. 365
Platform
  1. Windows
conditional formatting won't work... i wouldn't have wasted your time if it had done!
 

arthurbr

Well-known Member
Joined
Dec 8, 2006
Messages
2,082
Office Version
  1. 2010
Don't know how to highlight with a formula. Sorry
 

Watch MrExcel Video

Forum statistics

Threads
1,109,029
Messages
5,526,340
Members
409,697
Latest member
christopherlewis1620

This Week's Hot Topics

Top