LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
viktor
 
Posts: n/a
Default Calculate date

hi,

how can i calculate the end date(mm/yyyy) betwen one cell where i have a
date(dd/mm/yyyy) and in another cell i have a number of month(12)

ex: A1: 01/01/2005 B1: 12 in C1 i should obtain 12/2005

Thanks
 
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
formula to calculate age using birth date and current date lalah Excel Worksheet Functions 2 November 20th 05 10:51 PM
Calculate a biweekly date TimT Excel Discussion (Misc queries) 2 November 18th 05 05:03 PM
calculate the number of days from date received Donna Excel Worksheet Functions 7 July 18th 05 07:00 PM
calculate date differences in years and months Joyce Excel Worksheet Functions 1 March 14th 05 05:18 PM
How do I use the IF function to calculate date Pulling My Hair Out! Excel Discussion (Misc queries) 1 December 10th 04 11:03 PM


All times are GMT +1. The time now is 10:07 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"