I wanna show days and numbers automatically or with formulas

  • Thread starter Thread starter bren
  • Start date Start date
B

bren

Hi,

I want to build a kind of schedule, so that if I write or introduce
the month in a cell the first row shows all the days of the month and
in the second all the days of the week corresponding to each number of
day. Is this possible?

Thank you.
 
if I write or introduce the month in a cell

And how will you be doing that?

A1: Jan
A1: January
A1: 1/1/2009
 
Try this...

A1 = some month name as TEXT like January

Enter this formula in B1:

=IF(A1="",TODAY()-DAY(NOW())+1,--("1-"&A1))

Enter this formula in C1 and copy across to AF1:

=IF(DAY(IF(B1="",0,B1)+1)>DAY($B1),B1+1,"")

Format as Date

For the weekdays enter this formula in B2 and copy across to AF2:

=B2

Format as Custom dddd

If A1 is an empty cell the dates generated will be for the current month.
 
Back
Top