Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
sunderland27
 
Posts: n/a
Default date formulas

Orig Hire Date Term Date Rehire Date Difference New
Conv Date
09/15/2005 03/22/2006 04/15/2006 24 04/15/2006

if Difference is less than or equal to 30, then New Covg should be first of
the month following the Rehire Date unless Rehire Date is on the first, in
which case New Covg should be the Rehire Date

does anyone have an idea on how to do this. i have some ideas but wondering
if they will work. 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
Insert Automatic, Non-Updating Date Stamp Ken Zenachon Excel Discussion (Misc queries) 8 January 18th 06 06:52 PM
Need to Improve Code Copying/Pasting Between Workbooks David Excel Discussion (Misc queries) 1 January 6th 06 03:56 AM
Date formulas needed David Excel Discussion (Misc queries) 9 July 24th 05 02:01 AM
Min/Max formulas using cells with date format WDS2000 Excel Worksheet Functions 1 February 7th 05 06:03 PM
Using formulas to determine date in one cell based on date in anot Gary Excel Worksheet Functions 2 November 22nd 04 08:11 AM


All times are GMT +1. The time now is 03:45 PM.

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"