EXCEL DATE FORMULA (TRICKY)
Closed
Report
Abbas

rizvisa1
rizvisa1
 Posts
 4476
 Registration date
 Thursday January 28, 2010
 Status
 Contributor
 Last seen
 August 2, 2020
Related:
 EXCEL DATE FORMULA (TRICKY)
 Excel @ in formula ✓  Forum  Excel
 How to copy data from one sheet to another in excel using formula  Guide
 Excel position formula ✓  Forum  Office Software
 Copying data from one Excel sheet to another. ✓  Forum  Excel
 Excel  Countif formula issue  HowTo  Excel
2 replies
rizvisa1
 Posts
 4476
 Registration date
 Thursday January 28, 2010
 Status
 Contributor
 Last seen
 August 2, 2020
I am not sure about if dates are in future or past etc
How ever you can use date manipulation to see if this date fall in other month. Some thing like this
IF(TEXT(A1,"YYYYMM")=TEXT(DATE(YEAR(TODAY()),MONTH(TODAY())1,DAY(TODAY())),"YYYYMM")) "A1 month is one month prior to this month", "A1 month is NOT one month prior to this month")
How ever you can use date manipulation to see if this date fall in other month. Some thing like this
IF(TEXT(A1,"YYYYMM")=TEXT(DATE(YEAR(TODAY()),MONTH(TODAY())1,DAY(TODAY())),"YYYYMM")) "A1 month is one month prior to this month", "A1 month is NOT one month prior to this month")
venkat1926
 Posts
 1864
 Registration date
 Sunday June 14, 2009
 Status
 Contributor
 Last seen
 August 7, 2021
if invoice date is 20th June 2010 and on 30th June number of days elapsed is 10 days. on July 1st it is only 11 days how can that be in the interval 3160 days.
This argument of mine shows that I have NOT understood you. please clarify
This argument of mine shows that I have NOT understood you. please clarify
This does not happen for other age groups only for the 030 days age group. Hope u can help.
This is marking for you the dates where month have changed and date elaspsed betweeen todays date and the invoice date is less than 30. You just have to incorporate into your formula this logic
I am using the following formula to shift the invoices to diff age groups
030 days
=IF(AND($L9<=30),$F9*1,"0")
where L counts number of days since the invoice was generated.
3160 days
=IF(AND($L9<=60,$L9>30),$F9*1,"0")
etc
can u help how to amend this formula to ur solution.