View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
MelB MelB is offline
external usenet poster
 
Posts: 23
Default formula calculating date

I have the current date in cell A1 =TODAY(). In cell A2 I need the next
10th. So, if todays date is 12/13/07 I need A2 to return 1/10/08. If
today's date is 2/9/08 I need the date 2/10/08 returned in cell A2.