PC Review


Reply
Thread Tools Rate Thread

days and dates - ajit

 
 
Ajit Munj
Guest
Posts: n/a
 
      10th Dec 2007
I want excel to fill the days and dates automatically
when I change the month in cell a1 for me. How can I do so?
ajit

--
Knowldege is Power
 
Reply With Quote
 
 
 
 
Bob Phillips
Guest
Posts: n/a
 
      10th Dec 2007
A1: the nominated month as text, say May

C1: =DATEVALUE("01-"&A1&"-"&YEAR(TODAY()))
C2: =IF(OR(C1="",MONTH(C1+1)<>MONTH(C1)),"",C1+1)

and copy C2 down

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Ajit Munj" <(E-Mail Removed)> wrote in message
news:EAA4AC28-30C1-4859-8EAF-(E-Mail Removed)...
>I want excel to fill the days and dates automatically
> when I change the month in cell a1 for me. How can I do so?
> ajit
>
> --
> Knowldege is Power



 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Calc days between two dates and exclude leap year days scoz Microsoft Excel Worksheet Functions 5 23rd Nov 2007 03:58 PM
Conditional Formatting Dates calculating 10 days and 30 days from a certain date Sioux Microsoft Excel Worksheet Functions 2 11th Oct 2007 02:04 PM
Determine dates by number of days, "what date is 180 days from now =?Utf-8?B?VFJMYW1i?= Microsoft Outlook Calendar 2 19th Apr 2007 03:30 PM
count conditional days - ajit =?Utf-8?B?QWppdCBNdW5q?= Microsoft Excel Misc 6 16th Mar 2005 09:09 AM
days in month - Ajit =?Utf-8?B?QWppdCBNdW5q?= Microsoft Excel Misc 11 11th Mar 2005 06:03 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:55 AM.