Hello Dear, Please read and use the following instruction.
Populating Date In Excel • Populate today's date with the Today function. Type "=TODAY()" in a blank cell to return today's date. The Now function returns the date and the time stamp: "=NOW()". • Step 2 Calculate a future date by entering a date in a cell. Click on an empty cell and type "=cell reference+number of days" where cell reference refers to the date that was entered and the number of days should be substituted for the actual number of days you want to calculate. For example, if we enter 5/22/2009 in cell A1 and want to know what the date will be in 21 days, the formula would be "=A1+21", which returns 6/12/2009. • Step 3 Calculate a past date following the same procedure as in Step 2, but replace the plus sign with a minus. For example, if we enter 5/22/2009 in cell A1 and want to know what the date was 13 days ago, the formula would be "=A1-13", which returns 5/9/2009. • Step 4 Calculate the number of days between two dates with the DAYS360 formula. Enter a start date and end date in two cells. Click on an empty cell and type "=DAYS360(start date,end date)", where the start and end dates would be substituted with cell references. In our example in Step 3, if we had the original date of 5/22/2009 in cell A1 and the calculated end date in B1, the formula would be =DAYS360(B1,A1), which returns 13 days. Hope it Will Help Happy to Help :) On Tue, Apr 13, 2010 at 1:09 PM, Sundarvelan N <nsund...@gmail.com> wrote: > Hi Group, > > Im doing a project in which i need to add date "From" date as first of the > Current month and "To" date should be current date > > Please help me in this regard. > > Thanks, > N.Sundarvelan > > -- > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our Facebook Group @ > http://www.facebook.com/group.php?gid=287779555678 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 6,800 subscribers worldwide and receive many nice notes about > the learning and support from the group.Let friends and co-workers know they > can subscribe to group at > http://groups.google.com/group/excel-macros/subscribe > -- Thanks Regards Shyam Software Engineer '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' When one door of happiness closes, another opens; but often we look so long at the closed door that we do not see the one which has been opened for us. - Helen Keller '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' Wenn eine Tür des Glücks schließt, öffnet sich ein weiteres, aber oft schauen wir so lange auf die geschlossene Tür, dass wir nicht sehen ein, die für uns geöffnet wurde. - Helen Keller '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe To unsubscribe, reply using "remove me" as the subject.
