To detect month or days or year in if formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi fren,

Can anybody show me how to detect particular month in if formula. E.g is in
A1 cell the data is 01/10/2006. The formula that I want to do is if the month
in cell A1 is '10', then B18*2 . Ok thanks fren.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula for calculating storage days 11
Calculating Years and Months Between Dates 2
Date(Year,Month,Day) not returnign correct date 6
Last working day of a month 12
First day of Next Month 5
Need cell formulas to return the day of every Monday in a month based on year entered 3
FORMULA NEEDED FOR MONTHS 1
If statement with dates 0

Back
Top