#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 44
Default date comparision

pls help me out

i have the data as below START DT(A1), END DT(B1), QUARTERLY COMMISSION DT.
(C1, D1.....)
A1 B1 C1 D1 E1
F1 G1
06.01.10 30.01.11 06.04.10 06.07.10 06.10.10
06.01.11 EXPIRD

HERE I WANT TO HAVE A FORMULA TO DRAG FROM C1 TILL I GET "expird" (WHEREIN I
SHOULD GET THE DATES FOR EVERY QUARTER FROM THE START DT. TILL THE EXPIRY
DT. AS ABOVE)

I HAVE USED THE BELOW FORMULA BUT THERE ARE ERRORS PLEASE CORRECT AND HELP ME
IF(DATE(YEAR(C2),MONTH(C2)+3,DAY(C2)<$B2),(DATE(YE AR(C2),MONTH(C2)+3,DAY(C2))))

THANKS IN ADVANCE
Reply
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
dates comparision surya and siva[_2_] New Users to Excel 1 July 1st 09 05:39 PM
date range comparision on a criteria TUNGANA KURMA RAJU Excel Discussion (Misc queries) 0 April 20th 09 09:55 PM
Date comparision Murray Excel Discussion (Misc queries) 3 September 8th 06 04:58 AM
text comparision Blah Excel Discussion (Misc queries) 5 July 19th 06 02:13 AM
Comparision formula manasi New Users to Excel 1 September 20th 05 07:06 PM


All times are GMT +1. The time now is 03:54 AM.

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

About Us

"It's about Microsoft Excel"