Thread: Need a function or formulae that will return the current date + 1
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Flintstone Flintstone is offline
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 With QuoteReply With Quote