LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 122
Default Time and Date Question

I have column A with date (mm,dd,yyy) I would like excel to
calculate....the first day of the month following 3 months after the
date entered.

In other words, date entered is 10/07/2007, excel should return
February 1, 2008. 3 full months would be January 7, 2007 (or8th) and
the answer returned should be the 1st of the next month after 3 full
months.

Thank you all so much for all of your help on my numerous posts! This
is a fabulous group of professionals always willing to help!

 
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
Date time format question please ferde Excel Discussion (Misc queries) 7 August 20th 07 06:00 PM
Microsoft Date and Time Picker Control 6.0 (SP6) question [email protected] Excel Discussion (Misc queries) 0 July 23rd 07 08:00 PM
Another question about time and date ECLynn Excel Discussion (Misc queries) 2 August 30th 06 10:13 PM
question about entering date and time changetires Excel Discussion (Misc queries) 3 July 18th 06 02:38 PM
Date/Time Question bladelock Excel Worksheet Functions 2 November 10th 05 02:42 AM


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