Thread: Excel formula from looking the base date and convert into desire result
View Single Post
 
Old 02-16-2013, 03:46 AM
PRADEEPB270's Avatar
PRADEEPB270 PRADEEPB270 is offline Windows Vista Office 2007
Novice
  
Join Date: Aug 2011
Location: Gurgaon-INDIA
Posts: 17
PRADEEPB270 is on a distinguished road
Default Excel formula from looking the base date and convert into desire result
I have an excel file.I want to solve the category condition from an excel formula.In this file,G3 will be my base date and I want the excel formula in colum no.I i.e.Category.For this,look the base date i.e.G3 and compare to column F i.e.Date Column of each material code.

For more clarification,please refer the attach file

Regards
Attached Files
File Type: xlsx Date Calculation.xlsx (9.2 KB, 17 views)
Reply With Quote