Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
RADIOOZ
 
Posts: n/a
Default trying to get day/month/year froamt while user enters year only

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
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Bob Phillips
 
Posts: n/a
Default trying to get day/month/year froamt while user enters year only

You would just use something like

=DATE(2006,1,ROW())

copied down, but I am not clear where the year number is stored, and when
the flip to column B happens.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"RADIOOZ" wrote in message
...
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



  #3   Report Post  
Posted to microsoft.public.excel.newusers
Marcelo
 
Posts: n/a
Default trying to get day/month/year froamt while user enters year only

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

  #4   Report Post  
Posted to microsoft.public.excel.newusers
RADIOOZ
 
Posts: n/a
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
user form question: text box to display result BigPig Excel Discussion (Misc queries) 0 February 28th 06 01:33 AM
user form question: text box to display result BigPig Excel Worksheet Functions 0 February 25th 06 09:17 PM
Cells User Select Locked after upgrade to Excel 2002 TWilson Excel Discussion (Misc queries) 1 August 5th 05 12:22 PM
Finding a record based on user input Soundman Excel Discussion (Misc queries) 5 June 21st 05 03:06 AM
Month Year Date Format Jamie Excel Worksheet Functions 2 February 7th 05 07:43 PM


All times are GMT +1. The time now is 03:30 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"