Date based dynamic line

Question

Hi all,

I have have excel spreadsheet tracking tasks.

On row 2 I have the months of the year, row 3 the dates within that month, then row 4 is Mon - Sun.

So for August:

Row 2, column N to AR is merged and says August

Row 3, column N says 1, O says 2 etc through to AR which has 31

What I was hoping is to have a line down the page, which shows which day we are on. If I had A1 as =TODAY(), can I use that to plot a line at 13th August, so in this spreadsheet that would be column Y?

Thanks

Answer 1

I've managed to come up with a working solution.

Row 4 I've put all the dates, then changed the format from DD/MM/YY to just DD.

Then ive set conditional format to say if a date in row 4 equals the date in A1, put a border around the cells in that column

Answer 2

Hi Daniel,

Glad to know you found the solution, thanks for sharing, this will benefit other community members who come across this thread.

Hope you have a nice day and stay safe!

Best Regards,

Tina

Answer 3

If it helps, I have just amended the spreadsheet so that row 4 is the full date now