LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
BLW
 
Posts: n/a
Default adding months to an inputted date

I need a function that will take a date that a user has typed in a different
cell and will then add two months to the date. For instance, if I type
"2/12/05" in B1, then I want C2 to be: "4/12/05". Thank you for any help
that you may be able to give.

Logan
 
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
adding occurrences for date range Mike Excel Discussion (Misc queries) 1 April 28th 05 09:14 PM
Excel Adding years or months to a date Joan Excel Discussion (Misc queries) 2 April 25th 05 08:09 PM
adding occurrences for date range Mike Excel Discussion (Misc queries) 0 April 11th 05 05:24 PM
adding occurrences for date range Mike Excel Discussion (Misc queries) 0 April 8th 05 11:33 PM
Return a date 6 months from a date in another cell Qaspec Excel Worksheet Functions 1 January 21st 05 04:59 PM


All times are GMT +1. The time now is 09:58 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"