Thread: [Solved] Turn a number into a date from today
View Single Post
 
Old 01-16-2017, 08:11 AM
jeffreybrown jeffreybrown is offline Windows Vista Office 2007
Expert
  
Join Date: Apr 2016
Posts: 673
jeffreybrown has a spectacular aura aboutjeffreybrown has a spectacular aura about
Default
You can simply add 45 to a date. A date is nothing but a number.

Today's date >> 16-Jan-17 equals 42751

45 + 42751 = 42751 >> equals 2-Mar-17

http://www.cpearson.com/excel/datetime.htm
Reply With Quote