Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 51
Default Need a function or formulae that will return the current date + 1

Would also be helpful if there were similar formulae that would provide the
ability to either add 1 day or add 1 year to the current date......Of course
it needs to take into account leap years and other problems.....can anyone
help
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Need a function or formulae that will return the current date + 1


To return the Current Date + 1 Day use

=Today() + 1

To return the Current Date + 1 Year

=DATE(YEAR(TODAY()) +1,MONTH(TODAY()),DAY(TODAY()))

You mention that it has to account for leap years. What do you mean by
that? If you replace the +1 with +3 in the formula above to add three
years to today (and thus cross over 2008 which is the next leap year)
the date returned is 7/27/09. Is this not the answer you are looking
for?


scott56hannah Wrote:
Would also be helpful if there were similar formulae that would provide
the
ability to either add 1 day or add 1 year to the current date......Of
course
it needs to take into account leap years and other problems.....can
anyone
help



--
Excelenator


------------------------------------------------------------------------
Excelenator's Profile: http://www.excelforum.com/member.php...o&userid=36768
View this thread: http://www.excelforum.com/showthread...hreadid=565827

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 964
Default Need a function or formulae that will return the current date + 1

The formula:

=TODAY()+1

will add 1 day to today's date.

You could also use:

=DATE(YEAR(TODAY())+3,MONTH(TODAY())+4,DAY(TODAY() )+2)

This will add 3 years, 4 months and 2 days to today's date.

HTH,
Elkar



"scott56hannah" wrote:

Would also be helpful if there were similar formulae that would provide the
ability to either add 1 day or add 1 year to the current date......Of course
it needs to take into account leap years and other problems.....can anyone
help

  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Need a function or formulae that will return the current date + 1


Scott56hannah:

Leap Years should not be a problem that I can see, and you should
specify in more detail when you say, “other problems”. However, this
formula will determine if it is a leap year or not.

=IF(MOD(YEAR(A1),4)=0,"YES","NO")

Since Feb. 29th can’t exist in Feb. unless it is a Leap Year, Excel
will automatically accommodate by your adding 1 day to make it either
the 29th or the 01st of Mar. Use this formula.

=DATE(YEAR(A1)+1,MONTH(A1),DAY(A1)+1)

Matt


--
Flintstone
------------------------------------------------------------------------
Flintstone's Profile: http://www.excelforum.com/member.php...o&userid=15310
View this thread: http://www.excelforum.com/showthread...hreadid=565827

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
Can a function return a Null (blank ) value? Maybe a custom functi colin_e Excel Worksheet Functions 2 March 16th 06 03:36 PM
Date formula and if function alane Excel Worksheet Functions 4 January 28th 06 02:11 AM
Return a specified date when it falls within a range.... Nokose451 Excel Discussion (Misc queries) 1 January 16th 06 11:06 PM
Formula Meaning Bevatron Excel Discussion (Misc queries) 17 January 10th 06 07:32 PM
Date Function LisaS Excel Discussion (Misc queries) 1 July 27th 05 08:36 PM


All times are GMT +1. The time now is 10:24 AM.

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"