trying to get day/month/year froamt while user enters year onl
Thanks Marcelo
just what I wanted
"Marcelo" wrote:
Hi Radiooz,
Assuming that you have the year on A1,
on A2 you can use the formula =Date(a1,1,1) and it will return 01/Jan/aaaa.
on A3 the formula could be =A2+1
on A4 the formula could be =A3+1
etc...
Just format it as your convenience
for the B Column, =weekday(a2). format it as "ddd" for Sun or "dddd" for
Sunday.
hope it heps.
regards from Brazil
Marcelo
"RADIOOZ" escreveu:
I am trying to get the end user to enter the year in question and then have
the document return values in column A in dd/mmm/yyyy format and column B
in Day of week format for all days in that year
|