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  HowTo  Excel
 How To Copy Data from One Excel Sheet to Another Using a Formula  HowTo  Excel
 Excel position formula ✓  Forum  Office Software
 Excel show formula bar  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
=IF(TEXT(E4,"YYYYMM")=TEXT(DATE(YEAR(TODAY()),MONTH(TODAY())1,DAY(TODAY())),"YYYYMM"),64,DAYS360($E4,$N$1))