timeline

[Lynn]

how can i draw a monthly timeline in excel to visually tell the
recipient where are we now

 

[Bernard Liengme]

If I understand the question:
In A1 enter the formula =DATE(YEAR(TODAY()),MONTH(TODAY()),1)
In 2 enter =A1+1
Copy A2 down to A31
Select A1:A31; use Format | Conditional Formatting with Formula Is
=A1=TODAY() and set a background colour.
Now the cell with today's date is highlighted

If you wish, add another conditional format with Formula Is
=MONTH(A1)<>MONTH(TODAY()) and with the format dialog make the font the came
colour as the cell background. Now days that are actually part of next month
will be invisible.

 

[Lynn]

this is what i want to achieve, but in a nicer manner

Jan Feb Mar Apr May Jun
Jul Aug
----0-----0-----0---------------------0----------0--------------0---------------0-------------

 

[Bernard Liengme]

What cell do you want "Feb" to be in
I assume the text and the month are to go up to only today

Try this and tell me if it is close
In A1:B1 type "Jan" and "Feb"; drag along to L1 to get all the months
Select A1:L1 and use conditional formatting Formula Is
=COLUMN(A1)>MONTH(TODAY())
and set the font colour the same as worksheet background (white?) to make
future months invisible

In A2 enter
=IF(COLUMN(A1)=MONTH(TODAY()),TODAY(),IF(COLUMN(A1)>MONTH(TODAY()),"",DATE(YEAR(TODAY()),COLUMN(A1)+1,0)))
drag this to L2

Now you will see
Jan Feb Mar Apr May Jun Jul
31 28 31 30 31 30 07


If this is close to what you want, we need to adjust things if your timeline
starts in a column other than A

best wishes